APPS.PAY_IE_P35_XML_PKG dependencies on PER_ASSIGNMENTS_F

Line 135: per_assignments_f paaf,

131: pay_payroll_actions ppa,
132: pay_assignment_actions paad,
133: pay_action_information pactd,
134: pay_action_information pai,
135: per_assignments_f paaf,
136: pay_all_payrolls_f ppf,
137: hr_soft_coding_keyflex flex
138: WHERE paa.payroll_action_id = ppa.payroll_action_id
139: AND paa.action_status = 'C'

Line 171: AND (ppf.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b

167: 'END_DATE'
168: ),
169: 'YYYY/MM/DD'
170: ) BETWEEN l_start_date AND l_end_date
171: AND (ppf.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b
172: where a.payroll_id = l_p_payroll
173: and a.person_id = b.person_id
174: and a.person_id = paaf.person_id
175: --bug 6642916

Line 182: , per_assignments_f paf

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
186: AND hasa.assignment_id = paf.assignment_id

Line 192: , per_assignments_f paf

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
196: AND hasa.assignment_id = paf.assignment_id