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 281: pay_payrolls_f ppf

277: --
278: select max(ppf.effective_end_date)
279: into l_virtual_date2
280: from per_assignments_f paf,
281: pay_payrolls_f ppf
282: where paf.assignment_id = p_assignment_id
283: and paf.payroll_id = ppf.payroll_id
284: and ppf.effective_end_date between
285: trunc(p_virtual_date, p_balance_time)

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

901: */
902:
903: CURSOR c_get_min_aaid(p_start_date date , p_end_date date,p_bg_id number) is
904: select nvl(min(assignment_action_id),-1)
905: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf
906: where ppa.business_group_id +0 = p_bg_id
907: and ppa.payroll_action_id = paa.payroll_action_id
908: and ppa.effective_date between p_start_date and p_end_date
909: and ppa.action_type in ('R','Q','I','B','V')

Line 1301: pay_payrolls_f ppf

1297: select min(paa.assignment_id)
1298: into l_assignment_id
1299: from pay_assignment_actions paa,
1300: pay_payroll_actions pact,
1301: pay_payrolls_f ppf
1302: where pact.effective_date <= l_virtual_date
1303: and pact.payroll_action_id=paa.payroll_action_id
1304: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')
1305: and paa.tax_unit_id = p_gre_id_context