DBA Data[Home] [Help]

APPS.PQP_GB_PCSPS_PENSIONPAY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 106: pay_assignment_actions paa

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
110: AND paa.assignment_id = p_assignment_id