APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PAYROLLS_F

Line 185: ,pay_payrolls_f pp

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
189: and ppa.effective_date between pp.effective_start_date

Line 207: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;

203: ln_pre_pay_id number;
204: ln_prepay_asg_act number;
205: ld_payroll_start_date date;
206: ld_payroll_end_date date;
207: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
208: lv_legislation_install varchar2(2);
209:
210: l_proc_name varchar2(100);
211: ld_effective_date date;