APPS.PAY_MX_YREND_ARCH dependencies on HR_ASSIGNMENT_SETS

Line 666: FROM hr_assignment_sets has,

662: AND paf.effective_end_date
663: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
664: AND EXISTS
665: (SELECT ''x''
666: FROM hr_assignment_sets has,
667: hr_assignment_set_amendments hasa,
668: per_assignments_f paf_all
669: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
670: AND has.assignment_set_id = hasa.assignment_set_id

Line 705: FROM hr_assignment_sets has,

701:
702: CURSOR c_chk_asg (cp_asg_set_id NUMBER,
703: cp_asg_id NUMBER) IS
704: SELECT 'X'
705: FROM hr_assignment_sets has,
706: hr_assignment_set_amendments hasa
707: WHERE has.assignment_set_id = cp_asg_set_id
708: AND has.assignment_set_id = hasa.assignment_set_id
709: AND hasa.assignment_id IN (SELECT DISTINCT