APPS.PAY_NL_WW_ADJUSTMENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 206: per_all_assignments_f paa,

202:
203: CURSOR csr_get1(c_si_type VARCHAR2, c_assignment_action_id NUMBER) IS
204: SELECT distinct hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) si_provider_id
205: FROM
206: per_all_assignments_f paa,
207: per_all_assignments_f paa1,
208: pay_assignment_actions pac
209: WHERE
210: pac.assignment_action_id=c_assignment_action_id

Line 207: per_all_assignments_f paa1,

203: CURSOR csr_get1(c_si_type VARCHAR2, c_assignment_action_id NUMBER) IS
204: SELECT distinct hr_nl_org_info.GET_SI_PROVIDER_INFO(paa.organization_id, c_si_type, paa.assignment_id) si_provider_id
205: FROM
206: per_all_assignments_f paa,
207: per_all_assignments_f paa1,
208: pay_assignment_actions pac
209: WHERE
210: pac.assignment_action_id=c_assignment_action_id
211: AND paa1.assignment_id = pac.assignment_id

Line 280: per_all_assignments_f paaf,

276: from pay_action_contexts
277: where context_id IN (select context_id from ff_contexts
278: where context_name = 'SOURCE_TEXT2')
279: and assignment_action_id in (select paa.assignment_action_id from
280: per_all_assignments_f paaf,
281: pay_assignment_Actions paa,
282: pay_payroll_actions ppa,
283: per_time_periods ptp
284:

Line 285: where paaf.person_id = (select distinct(person_id) from per_all_assignments_f

281: pay_assignment_Actions paa,
282: pay_payroll_actions ppa,
283: per_time_periods ptp
284:
285: where paaf.person_id = (select distinct(person_id) from per_all_assignments_f
286: where assignment_id = p_assignment_id)
287: and paaf.assignment_id = paa.assignment_id
288: and paa.payroll_action_id = ppa.payroll_action_id
289: -- and ppa.payroll_id = ptp.payroll_id