DBA Data[Home] [Help]

APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_PAYROLL_ACTIONS

Line 94: FROM pay_payroll_actions ppa,

90: ,p_effective_date date)
91: is
92: SELECT max(paa.assignment_action_id) ASSIGNMENT_ACTION_ID
93: ,max(ppa.payroll_action_id) PAYROLL_ACTION_ID
94: FROM pay_payroll_actions ppa,
95: pay_assignment_actions paa
96: WHERE ppa.action_type in ('Q','R')
97: AND paa.action_status = 'C'
98: AND ppa.business_group_id = p_business_group_id