DBA Data[Home] [Help]

APPS.PQP_GB_PCSPS_PENSIONPAY dependencies on PAY_PAYROLL_ACTIONS

Line 105: FROM pay_payroll_actions ppa,

101: ,p_effective_date date)
102: is
103: SELECT max(paa.assignment_action_id) ASSIGNMENT_ACTION_ID
104: ,max(ppa.payroll_action_id) PAYROLL_ACTION_ID
105: FROM pay_payroll_actions ppa,
106: pay_assignment_actions paa
107: WHERE ppa.action_type in ('Q','R')
108: AND paa.action_status = 'C'
109: AND ppa.business_group_id = p_business_group_id