APPS.PAY_NL_WW_ADJUSTMENTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 208: pay_assignment_actions pac

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
212: AND paa1.person_id = paa.person_id

Line 281: pay_assignment_Actions paa,

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:
285: where paaf.person_id = (select distinct(person_id) from per_all_assignments_f

Line 295: from pay_payroll_actions ppa1, pay_assignment_Actions paa1

291: AND ppa.action_type in ('R','Q','V','B','I')
292: and paa.source_action_id is NOT NULL
293: -- and ptp.time_period_id = ppa.time_period_id
294: and ptp.time_period_id IN (select ppa1.time_period_id
295: from pay_payroll_actions ppa1, pay_assignment_Actions paa1
296: where paa1.assignment_action_id = p_assignment_action_id
297: and paa1.payroll_action_id = ppa1.payroll_action_id)
298: and ppa.date_earned between ptp.start_date and ptp.cut_off_date);
299: RETURN l_si_prov_count;