APPS.HR_PUMP_GET dependencies on PAY_RATES

Line 676: from pay_rates

672: l_rate_id number;
673: begin
674: select rate_id
675: into l_rate_id
676: from pay_rates
677: where name = p_rate_name
678: and business_group_id + 0 = p_business_group_id;
679: return(l_rate_id);
680: exception

Line 3349: pay_rates pr

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
3352: and pr.name = p_rate_name
3353: and pr.business_group_id + 0 = p_business_group_id

Line 3385: pay_rates pr

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
3389: and psp.business_group_id + 0 = p_business_group_id

Line 3421: pay_rates pr

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
3425: and pgr.rate_type = 'A'

Line 4160: pay_rates pr

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
4163: and pr.name = p_rate_name
4164: and pr.business_group_id + 0 = p_business_group_id

Line 4196: pay_rates pr

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
4200: and psp.business_group_id + 0 = p_business_group_id