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_BAL_SUMMARY_PKG dependencies on PAY_US_LOCAL_TAX_TYPES_V

Line 640: pay_us_local_tax_types_v petv ,

636: , city.jurisdiction_code
637: FROM
638: pay_assignment_actions paa ,
639: pay_payroll_actions ppa ,
640: pay_us_local_tax_types_v petv ,
641: pay_us_emp_city_tax_rules_f city ,
642: pay_us_city_names names ,
643: pay_us_city_tax_info_f citf
644: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 713: pay_us_local_tax_types_v petv

709: , tax_type_code
710: , balance_category_code
711: , p_jurisdiction_code jurisdiction_code
712: FROM
713: pay_us_local_tax_types_v petv
714: WHERE petv.tax_type_code = 'COUNTY'
715: AND p_eff_date between petv.effective_start_date AND petv.effective_end_date
716: AND petv.tax_type_code <> 'SCHOOL'
717: ORDER BY 2,3;

Line 756: FROM pay_us_local_tax_types_v petv

752: , 6) ordercol2
753: , tax_type_code
754: , balance_category_code
755: , p_jurisdiction_code jurisdiction_code
756: FROM pay_us_local_tax_types_v petv
757: WHERE p_eff_date between petv.effective_start_date AND petv.effective_end_date
758: AND petv.tax_type_code <> 'SCHOOL'
759: ORDER BY 2,3;
760:

Line 917: pay_us_local_tax_types_v petv ,

913: , balance_category_code
914: , city.jurisdiction_code
915: FROM pay_assignment_actions paa ,
916: pay_payroll_actions ppa ,
917: pay_us_local_tax_types_v petv ,
918: pay_us_emp_city_tax_rules_f city ,
919: pay_us_city_names names ,
920: pay_us_city_tax_info_f citf
921: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 980: pay_us_local_tax_types_v petv

976: , tax_type_code
977: , balance_category_code
978: , p_jurisdiction_code jurisdiction_code
979: FROM
980: pay_us_local_tax_types_v petv
981: WHERE petv.tax_type_code = 'COUNTY'
982: AND p_eff_date between petv.effective_start_date AND petv.effective_end_date
983: AND petv.tax_type_code = 'SCHOOL'
984: ORDER BY 2,3;

Line 1002: pay_us_local_tax_types_v petv ,

998: , balance_category_code
999: , jurisdiction_code
1000: FROM pay_assignment_actions paa ,
1001: pay_payroll_actions ppa ,
1002: pay_us_local_tax_types_v petv ,
1003: pay_us_asg_schools_v school
1004: WHERE paa.payroll_action_id = ppa.payroll_action_id
1005: AND school.assignment_id = paa.assignment_id
1006: AND school.tax_unit_id = paa.tax_unit_id