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 3376: pay_rates pr

3372: select pgr.grade_rule_id
3373: into l_grade_rule_id
3374: from pay_grade_rules_f pgr,
3375: per_grades_vl pg,
3376: pay_rates pr
3377: where pg.name = p_grade_name
3378: and pg.business_group_id + 0 = p_business_group_id
3379: and pr.name = p_rate_name
3380: and pr.business_group_id + 0 = p_business_group_id

Line 3412: pay_rates pr

3408: into l_grade_rule_id
3409: from per_parent_spines pps,
3410: per_spinal_points psp,
3411: pay_grade_rules_f pgr,
3412: pay_rates pr
3413: where pps.name = p_pay_scale
3414: and pps.business_group_id + 0 = p_business_group_id
3415: and psp.spinal_point = p_progression_point
3416: and psp.business_group_id + 0 = p_business_group_id

Line 3448: pay_rates pr

3444: begin
3445: select pgr.grade_rule_id
3446: into l_grade_rule_id
3447: from pay_grade_rules_f pgr,
3448: pay_rates pr
3449: where pr.name = p_rate_name
3450: and pr.business_group_id + 0 = p_business_group_id
3451: and pgr.rate_id = pr.rate_id
3452: and pgr.rate_type = 'A'

Line 4187: pay_rates pr

4183: select pgr.object_version_number
4184: into l_object_version_number
4185: from pay_grade_rules_f pgr,
4186: per_grades_vl pg,
4187: pay_rates pr
4188: where pg.name = p_grade_name
4189: and pg.business_group_id + 0 = p_business_group_id
4190: and pr.name = p_rate_name
4191: and pr.business_group_id + 0 = p_business_group_id

Line 4223: pay_rates pr

4219: into l_object_version_number
4220: from per_parent_spines pps,
4221: per_spinal_points psp,
4222: pay_grade_rules_f pgr,
4223: pay_rates pr
4224: where pps.name = p_pay_scale
4225: and pps.business_group_id + 0 = p_business_group_id
4226: and psp.spinal_point = p_progression_point
4227: and psp.business_group_id + 0 = p_business_group_id