[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