APPS.PAY_IE_P35_MAGTAPE dependencies on HR_ASSIGNMENT_SETS

Line 169: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;

165: l_start_date DATE;
166: l_end_date DATE;
167: l_bg_id NUMBER;
168: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
169: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
170: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
171: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
172:
173: CURSOR csr_get_flag_from_set

Line 175: SELECT DISTINCT hasa.include_or_exclude FROM hr_assignment_set_amendments hasa, hr_assignment_sets has

171: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
172:
173: CURSOR csr_get_flag_from_set
174: IS
175: SELECT DISTINCT hasa.include_or_exclude FROM hr_assignment_set_amendments hasa, hr_assignment_sets has
176: WHERE hasa.assignment_set_id = has.assignment_set_id
177: AND has.business_group_id = l_bg_id
178: AND has.assignment_set_id = l_assignment_set_id;
179:

Line 230: , hr_assignment_sets has

226: --AND PAY_IE_P35.check_assignment_in_set(paa.assignment_id,l_assignment_set_id,l_bg_id)=1;
227: AND ((l_assignment_set_id IS NOT NULL
228: AND (l_set_flag ='I' AND EXISTS(SELECT 1
229: FROM hr_assignment_set_amendments hasa
230: , hr_assignment_sets has
231: , per_assignments_f paf
232: --, pay_payrolls_f pay
233: --, hr_soft_coding_keyflex hflex
234: WHERE has.assignment_set_id = hasa.assignment_set_id

Line 244: , hr_assignment_sets has

240: --AND pay.soft_coding_keyflex_id = hflex.soft_coding_keyflex_id
241: --AND hflex.segment4 = l_segment4)
242: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
243: FROM hr_assignment_set_amendments hasa
244: , hr_assignment_sets has
245: , per_assignments_f paf
246: -- , pay_payrolls_f pay
247: -- , hr_soft_coding_keyflex hflex
248: WHERE has.assignment_set_id = hasa.assignment_set_id