DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_GRADE_RULES_F

Line 3660: FROM pay_grade_rules_f pgr

3656: --
3657: CURSOR csr_current_asg_rates IS
3658: SELECT pgr.grade_rule_id,
3659: pgr.object_version_number
3660: FROM pay_grade_rules_f pgr
3661: WHERE pgr.grade_or_spinal_point_id = p_assignment_id
3662: AND pgr.rate_type = 'A'
3663: AND p_new_end_date BETWEEN pgr.effective_start_date
3664: AND pgr.effective_end_date

Line 3673: FROM pay_grade_rules_f pgr

3669: CURSOR csr_future_asg_rates IS
3670: SELECT pgr.grade_rule_id,
3671: pgr.object_version_number,
3672: pgr.effective_start_date
3673: FROM pay_grade_rules_f pgr
3674: WHERE pgr.grade_or_spinal_point_id = p_assignment_id
3675: AND pgr.rate_type = 'A'
3676: AND p_new_end_date < pgr.effective_start_date
3677: AND p_mode='END';