APPS.PAY_IE_P35_XML_PKG dependencies on HR_ASSIGNMENT_SETS

Line 94: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has

90: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE;
91:
92: CURSOR csr_get_flag_from_set
93: is
94: select distinct hasa.include_or_exclude from hr_assignment_set_amendments hasa, hr_assignment_sets has
95: where hasa.assignment_set_id = has.assignment_set_id
96: and has.business_group_id = p_bg_id
97: and has.assignment_set_id = l_assignment_set;
98:

Line 180: , hr_assignment_sets has

176: and a.effective_end_date >= l_start_date) or l_p_payroll is null)
177: AND ((l_assignment_set is not null
178: AND (l_set_flag ='I' AND EXISTS(SELECT 1
179: FROM hr_assignment_set_amendments hasa
180: , hr_assignment_sets has
181: , per_assignments_f paf
182: WHERE has.assignment_set_id = hasa.assignment_set_id
183: AND has.business_group_id = p_bg_id
184: AND has.assignment_set_id = l_assignment_set

Line 190: , hr_assignment_sets has

186: AND paf.person_id = paaf.person_id)
187:
188: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
189: FROM hr_assignment_set_amendments hasa
190: , hr_assignment_sets has
191: , per_assignments_f paf
192: WHERE has.assignment_set_id = hasa.assignment_set_id
193: AND has.business_group_id = p_bg_id
194: AND has.assignment_set_id = l_assignment_set