APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 84: pay_assignment_actions paa

80: is
81: SELECT max(paa.assignment_action_id) ASSIGNMENT_ACTION_ID
82: ,max(ppa.payroll_action_id) PAYROLL_ACTION_ID
83: FROM pay_payroll_actions ppa,
84: pay_assignment_actions paa
85: WHERE ppa.action_type in ('Q','R')
86: AND paa.action_status = 'C'
87: AND ppa.business_group_id = p_business_group_id
88: AND paa.assignment_id = p_assignment_id