DBA Data[Home] [Help]

APPS.PQP_GB_TP_TYPE2_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 241: ,pay_payroll_actions ppa

237: ,c_effective_start_date date
238: ,c_effective_end_date date) is
239: select distinct(ptp.end_date) end_date
240: from per_time_periods ptp
241: ,pay_payroll_actions ppa
242: ,pay_assignment_actions paa
243: where ptp.time_period_id = ppa.time_period_id
244: and ppa.payroll_action_id = paa.payroll_action_id
245: and ppa.effective_date between c_effective_start_date