DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_GRADE_RULES_F

Line 3700: FROM pay_grade_rules_f pgr

3696: --
3697: CURSOR csr_current_asg_rates IS
3698: SELECT pgr.grade_rule_id,
3699: pgr.object_version_number
3700: FROM pay_grade_rules_f pgr
3701: WHERE pgr.grade_or_spinal_point_id = p_assignment_id
3702: AND pgr.rate_type = 'A'
3703: AND p_new_end_date BETWEEN pgr.effective_start_date
3704: AND pgr.effective_end_date

Line 3713: FROM pay_grade_rules_f pgr

3709: CURSOR csr_future_asg_rates IS
3710: SELECT pgr.grade_rule_id,
3711: pgr.object_version_number,
3712: pgr.effective_start_date
3713: FROM pay_grade_rules_f pgr
3714: WHERE pgr.grade_or_spinal_point_id = p_assignment_id
3715: AND pgr.rate_type = 'A'
3716: AND p_new_end_date < pgr.effective_start_date
3717: AND p_mode='END';