DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 880: hr_assignment_set_amendments hasa,

876: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
877: AND EXISTS
878: (SELECT ''x''
879: FROM hr_assignment_sets has,
880: hr_assignment_set_amendments hasa,
881: per_assignments_f paf_all
882: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
883: AND has.assignment_set_id = hasa.assignment_set_id
884: AND hasa.assignment_id = paf_all.assignment_id

Line 920: hr_assignment_set_amendments hasa

916: CURSOR c_chk_asg (cp_asg_set_id NUMBER,
917: cp_asg_id NUMBER) IS
918: SELECT 'X'
919: FROM hr_assignment_sets has,
920: hr_assignment_set_amendments hasa
921: WHERE has.assignment_set_id = cp_asg_set_id
922: AND has.assignment_set_id = hasa.assignment_set_id
923: AND hasa.assignment_id IN (SELECT DISTINCT
924: paf_all.assignment_id