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_TAXBAL_VIEW_PKG dependencies on PAY_US_ASG_REPORTING

Line 683: pay_us_asg_reporting PAR

679: c_date2_earned in date )
680: is
681: select distinct PAR.assignment_id
682: from pay_balance_types PBT,
683: pay_us_asg_reporting PAR
684: where PAR.tax_unit_id = c_tax_unit_id
685: and PBT.balance_type_id = c_balance_type_id
686: and PBT.jurisdiction_level <> 0
687: and substr(PAR.jurisdiction_code, 1, PBT.jurisdiction_level) =

Line 3952: from pay_us_asg_reporting puar

3948: , pay_run_results RR
3949: , pay_assignment_actions ASSACT
3950: , pay_payroll_actions PACT
3951: , (select distinct puar.assignment_id assignment_id
3952: from pay_us_asg_reporting puar
3953: where puar.tax_unit_id = c_tax_unit_id
3954: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT
3955: --
3956: where PACT.effective_date between trunc(c_effective_date,'Y')

Line 4066: from pay_us_asg_reporting puar

4062: , pay_run_results RR
4063: , pay_assignment_actions ASSACT
4064: , pay_payroll_actions PACT
4065: , (select distinct puar.assignment_id assignment_id
4066: from pay_us_asg_reporting puar
4067: where puar.tax_unit_id = c_tax_unit_id
4068: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT
4069: --
4070: where PACT.effective_date between trunc(c_effective_date,'Q')

Line 4686: from pay_us_asg_reporting puar

4682: , pay_run_results RR
4683: , pay_assignment_actions ASSACT
4684: , pay_payroll_actions PACT
4685: , (select distinct puar.assignment_id assignment_id
4686: from pay_us_asg_reporting puar
4687: where puar.tax_unit_id = c_tax_unit_id
4688: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT
4689: --
4690: where PACT.effective_date between trunc(c_effective_date,'MON')

Line 4803: from pay_us_asg_reporting puar

4799: , pay_run_results RR
4800: , pay_assignment_actions ASSACT
4801: , pay_payroll_actions PACT
4802: , (select distinct puar.assignment_id assignment_id
4803: from pay_us_asg_reporting puar
4804: where puar.tax_unit_id = c_tax_unit_id
4805: and puar.jurisdiction_code like substr(c_state_code,1,2)||'%') ASGRPT
4806: --
4807: where PACT.effective_date between c_start_date