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 170: AND (ppf.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b

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

Line 181: , per_assignments_f paf

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

Line 191: , per_assignments_f paf

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