APPS.HR_PUMP_GET dependencies on PAY_GRADE_RULES_F

Line 3347: from pay_grade_rules_f pgr,

3343: l_grade_rule_id number;
3344: begin
3345: select pgr.grade_rule_id
3346: into l_grade_rule_id
3347: from pay_grade_rules_f pgr,
3348: per_grades_vl pg,
3349: pay_rates pr
3350: where pg.name = p_grade_name
3351: and pg.business_group_id + 0 = p_business_group_id

Line 3384: pay_grade_rules_f pgr,

3380: select pgr.grade_rule_id
3381: into l_grade_rule_id
3382: from per_parent_spines pps,
3383: per_spinal_points psp,
3384: pay_grade_rules_f pgr,
3385: pay_rates pr
3386: where pps.name = p_pay_scale
3387: and pps.business_group_id + 0 = p_business_group_id
3388: and psp.spinal_point = p_progression_point

Line 3420: from pay_grade_rules_f pgr,

3416: l_grade_rule_id number;
3417: begin
3418: select pgr.grade_rule_id
3419: into l_grade_rule_id
3420: from pay_grade_rules_f pgr,
3421: pay_rates pr
3422: where pr.name = p_rate_name
3423: and pr.business_group_id + 0 = p_business_group_id
3424: and pgr.rate_id = pr.rate_id

Line 4158: from pay_grade_rules_f pgr,

4154: l_object_version_number number;
4155: begin
4156: select pgr.object_version_number
4157: into l_object_version_number
4158: from pay_grade_rules_f pgr,
4159: per_grades_vl pg,
4160: pay_rates pr
4161: where pg.name = p_grade_name
4162: and pg.business_group_id + 0 = p_business_group_id

Line 4195: pay_grade_rules_f pgr,

4191: select pgr.object_version_number
4192: into l_object_version_number
4193: from per_parent_spines pps,
4194: per_spinal_points psp,
4195: pay_grade_rules_f pgr,
4196: pay_rates pr
4197: where pps.name = p_pay_scale
4198: and pps.business_group_id + 0 = p_business_group_id
4199: and psp.spinal_point = p_progression_point