Skip to content

Instantly share code, notes, and snippets.

johnboychan

Block or report user

Report or block johnboychan

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View Misc eTime
select * from etime_access where uun = 'lhanks'
View grade_sp_salary_details
select pps.parent_spine_id, pps.name pay_scale, pg1.grade_id, pg1.name grade_name, psp.spinal_point_id, psp.spinal_point, pgrf.effective_start_date, pgrf.value salary
from per_parent_spines pps -- details of payscale
,per_grades pg1 -- grade definitions for a business group
,per_grade_spines_f pgsf -- stores the progression points for each grade scale
,per_spinal_point_steps_f pspsf -- grade steps definied in a specific grade scale and their incremental order
,per_spinal_points psp
,pay_grade_rules_f pgrf
where pg1.grade_id = pgsf.grade_id
and pg1.date_to is null
and sysdate between pgsf.effective_start_date and pgsf.effective_end_date
View fast_formula_01.sql
SELECT FORMU.BASE_FORMULA_NAME Formula_Name,
FTY.FORMULA_TYPE_NAME TYPE,
FORMU.EFFECTIVE_START_DATE Effective_Date,
FORMU.FORMULA_TEXT
FROM FF_FORMULAS_F_VL FORMU,
FF_FORMULA_TYPES FTY
WHERE FORMU.BUSINESS_GROUP_ID = 5000
AND FORMU.FORMULA_TYPE_ID = FTY.FORMULA_TYPE_ID;
You can’t perform that action at this time.