APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PAYROLL_ACTIONS

Line 180: ,pay_payroll_actions ppa

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