APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 502: FROM hr_assignment_set_amendments hasa,

498: AND asg.effective_end_date > ben_start_date(p_asg_id);
499: --
500: CURSOR check_asg_set_include(p_asg_id IN NUMBER) IS
501: SELECT 'Y' include_flag
502: FROM hr_assignment_set_amendments hasa,
503: hr_assignment_sets has,
504: per_all_assignments_f paaf
505: WHERE has.assignment_set_id = l_ext_asg_set_id
506: AND paaf.assignment_id = p_asg_id