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_US_TAX_BALS_PKG dependencies on PAY_PAYROLLS_F

Line 294: pay_payrolls_f ppf

290: --
291: select max(ppf.effective_end_date)
292: into l_virtual_date2
293: from per_assignments_f paf,
294: pay_payrolls_f ppf
295: where paf.assignment_id = p_assignment_id
296: and paf.payroll_id = ppf.payroll_id
297: and ppf.effective_end_date between
298: trunc(p_virtual_date, p_balance_time)

Line 918: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf

914: */
915:
916: CURSOR c_get_min_aaid(p_start_date date , p_end_date date,p_bg_id number) is
917: select nvl(min(assignment_action_id),-1)
918: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf
919: where ppa.business_group_id +0 = p_bg_id
920: and ppa.payroll_action_id = paa.payroll_action_id
921: and ppa.effective_date between p_start_date and p_end_date
922: and ppa.action_type in ('R','Q','I','B','V')

Line 1392: pay_payrolls_f ppf

1388: select min(paa.assignment_id)
1389: into l_assignment_id
1390: from pay_assignment_actions paa,
1391: pay_payroll_actions pact,
1392: pay_payrolls_f ppf
1393: where pact.effective_date <= l_virtual_date
1394: and pact.payroll_action_id=paa.payroll_action_id
1395: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')
1396: and paa.tax_unit_id = p_gre_id_context