DBA Data[Home] [Help]

APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 998: FROM hr_assignment_set_amendments hasa,

994: AND asg.effective_end_Date > l_ext_start_date;
995: --
996: CURSOR check_asg_set_include(p_asg_id IN NUMBER) IS
997: SELECT 'Y' include_flag
998: FROM hr_assignment_set_amendments hasa,
999: hr_assignment_sets has,
1000: per_all_assignments_f paaf
1001: WHERE has.assignment_set_id = l_ext_asg_set_id
1002: AND paaf.assignment_id = p_asg_id