DBA Data[Home] [Help]

APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_PAYROLL_ACTIONS

Line 83: FROM pay_payroll_actions ppa,

79: ,p_effective_date date)
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