eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PAYROLLS_F

Line 181: ,pay_payrolls_f pp

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

Line 203: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;

199: ln_pre_pay_id number;
200: ln_prepay_asg_act number;
201: ld_payroll_start_date date;
202: ld_payroll_end_date date;
203: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
204:
205: l_proc_name varchar2(100);
206: ld_effective_date date;
207: ln_assignment_action_id number;