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 181: , hr_assignment_sets has

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

Line 191: , hr_assignment_sets has

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