APPS.PAY_NL_WW_ADJUSTMENTS dependencies on PAY_PAYROLL_ACTIONS

Line 282: pay_payroll_actions ppa,

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
286: where assignment_id = p_assignment_id)

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;