APPS.PAY_IE_LE_MIGRATE dependencies on PAY_PAYROLL_ACTIONS

Line 53: pay_payroll_actions ppa

49: CURSOR c_get_asg_action(p_bg_id NUMBER,p_tax_unit_id NUMBER) IS
50: SELECT paa.*,ppa.action_type action_type,ppa.effective_date effective_date,
51: ppa.report_type,ppa.report_qualifier
52: FROM pay_assignment_actions paa,
53: pay_payroll_actions ppa
54: WHERE paa.payroll_action_id = ppa.payroll_action_id
55: AND paa.action_status IN ('C','S') --10225372
56: AND ppa.business_group_id = p_bg_id
57: AND ppa.action_type in ('R','Q','P','U','I','B','V','X')

Line 201: pay_payroll_actions ppa,

197: CURSOR c_get_asg_action(p_bg_id NUMBER,p_payroll_id NUMBER,p_start_date DATE,p_end_date DATE) IS
198: SELECT distinct paa.*,ppa.action_type action_type,ppa.effective_date effective_date,
199: ppa.report_type,ppa.report_qualifier,asg.person_id person_id
200: FROM pay_assignment_actions paa,
201: pay_payroll_actions ppa,
202: per_all_assignments_f asg
203: WHERE paa.payroll_action_id = ppa.payroll_action_id
204: AND paa.action_status IN ('C','S') --10225372
205: AND ppa.effective_date between p_start_date and p_end_date