APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PAY_GRADE_RULES

Line 374: FROM PAY_GRADE_RULES

370: Cursor C_Pay_Grade is
371: SELECT effective_start_date,effective_end_date,
372: rate_id, grade_or_spinal_point_id, rate_type,
373: maximum,mid_value,minimum,sequence,value
374: FROM PAY_GRADE_RULES
375: WHERE business_group_id = p_business_group_id
376: AND grade_rule_id = l_grade_rule_id;
377:
378: Cursor C_payscale is

Line 1051: FROM PAY_GRADE_RULES

1047: MID_VALUE,
1048: MINIMUM,
1049: SEQUENCE,
1050: VALUE
1051: FROM PAY_GRADE_RULES
1052: WHERE BUSINESS_GROUP_ID = p_business_group_id
1053: AND grade_rule_id > l_restart_grade_rule_id
1054: ORDER BY grade_rule_id;
1055: --

Line 1227: -- If pay_grade_rules.rate_type = 'SP' then

1223:
1224: l_grade_or_spinal_point_id := salary_rec.grade_or_spinal_point_id;
1225: l_rate_id := salary_rec.rate_id;
1226:
1227: -- If pay_grade_rules.rate_type = 'SP' then
1228: -- the salary type is 'Grade Scale'
1229:
1230: if (salary_rec.rate_type = 'SP') then
1231:

Line 1777: FROM PAY_GRADE_RULES

1773:
1774: /* Commented out and changed to enhance performance 23-NOV-2002*/
1775: /*Cursor C_grade_rate is
1776: SELECT rate_id
1777: FROM PAY_GRADE_RULES
1778: WHERE GRADE_OR_SPINAL_POINT_ID = l_grade_id
1779: and rate_type = l_rate_type; */
1780:
1781: Cursor C_grade_rate is