APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PAYROLL_ACTIONS

Line 184: ,pay_payroll_actions ppa

180: CURSOR get_payroll_details(p_prepay_asg_act in number) IS
181: SELECT ppa.start_date,ppa.effective_date,
182: pp.payroll_name
183: FROM pay_assignment_actions paa
184: ,pay_payroll_actions ppa
185: ,pay_payrolls_f pp
186: WHERE paa.assignment_action_id = p_prepay_asg_act
187: and ppa.payroll_action_id = paa.payroll_action_id
188: and pp.payroll_id = ppa.payroll_id