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_ASSIGNMENT_ACTIONS

Line 278: FROM pay_assignment_actions paa

274: CURSOR c_state_dt IS
275: SELECT DISTINCT
276: NVL(ppa.date_earned,ppa.effective_date)effective_date,
277: jurisdiction_code
278: FROM pay_assignment_actions paa
279: ,pay_us_emp_state_tax_rules_f pue
280: ,pay_payroll_actions ppa
281: WHERE paa.assignment_action_id = p_asact_id
282: AND pue.assignment_id = paa.assignment_id

Line 313: FROM pay_assignment_actions paa

309: , 6) ordercol2
310: , tax_type_code
311: , balance_category_code
312: , jurisdiction_code
313: FROM pay_assignment_actions paa
314: ,pay_payroll_actions ppa
315: ,pay_us_state_tax_types_v pstt
316: ,pay_us_emp_state_tax_rules_f pue
317: WHERE paa.assignment_action_id = p_asact_id

Line 388: FROM pay_assignment_actions paa

384: , 6) ordercol2
385: , tax_type_code
386: , balance_category_code
387: , jurisdiction_code
388: FROM pay_assignment_actions paa
389: ,pay_payroll_actions ppa
390: ,pay_us_state_liability_types_v pstt
391: ,pay_us_emp_state_tax_rules_f pue
392: WHERE paa.assignment_action_id = p_asact_id

Line 428: FROM pay_assignment_actions paa

424: , 6) ordercol2
425: , tax_type_code
426: , balance_category_code
427: , jurisdiction_code
428: FROM pay_assignment_actions paa
429: ,pay_payroll_actions ppa
430: ,pay_us_state_er_wage_types_v pstt
431: ,pay_us_emp_state_tax_rules_f pue
432: WHERE pue.assignment_id = paa.assignment_id

Line 638: pay_assignment_actions paa ,

634: , tax_type_code
635: , balance_category_code
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 ,

Line 673: pay_assignment_actions paa ,

669: SELECT DISTINCT
670: NVL(ppa.date_earned,ppa.effective_date)effective_date,
671: cnty.jurisdiction_code jurisdiction_code
672: FROM
673: pay_assignment_actions paa ,
674: pay_payroll_actions ppa ,
675: pay_us_emp_county_tax_rules_f cnty ,
676: pay_us_county_tax_info_f ctif ,
677: pay_us_counties names

Line 724: FROM pay_assignment_actions paa ,

720: CURSOR c_local_dt3 IS
721: SELECT DISTINCT
722: NVL(ppa.date_earned,ppa.effective_date)effective_date,
723: jurisdiction_code
724: FROM pay_assignment_actions paa ,
725: pay_payroll_actions ppa ,
726: pay_us_asg_schools_v school
727: WHERE paa.payroll_action_id = ppa.payroll_action_id
728: AND school.assignment_id = paa.assignment_id

Line 784: FROM pay_assignment_actions paa

780: , 6) ordercol2
781: , tax_type_code
782: , balance_category_code
783: , city.jurisdiction_code
784: FROM pay_assignment_actions paa
785: ,pay_payroll_actions ppa
786: ,pay_us_local_ee_wage_types_v petv
787: ,pay_us_city_names names
788: ,pay_us_emp_city_tax_rules_f city

Line 830: FROM pay_assignment_actions paa

826: , 6) ordercol2
827: , tax_type_code
828: , balance_category_code
829: , cnty.jurisdiction_code
830: FROM pay_assignment_actions paa
831: ,pay_payroll_actions ppa
832: ,pay_us_local_ee_wage_types_v petv
833: ,pay_us_emp_county_tax_rules_f cnty
834: ,pay_us_county_tax_info_f ctif

Line 860: FROM pay_assignment_actions paa

856: CURSOR c_local_dt6 IS
857: SELECT DISTINCT
858: NVL(ppa.date_earned,ppa.effective_date)effective_date,
859: jurisdiction_code
860: FROM pay_assignment_actions paa
861: , pay_payroll_actions ppa
862: , pay_us_asg_schools_v school
863: WHERE paa.payroll_action_id = ppa.payroll_action_id
864: AND school.assignment_id = paa.assignment_id

Line 915: FROM pay_assignment_actions paa ,

911: , 6) ordercol2
912: , tax_type_code
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 ,

Line 946: FROM pay_assignment_actions paa ,

942: CURSOR c_local_dt8 IS
943: SELECT DISTINCT
944: NVL(ppa.date_earned,ppa.effective_date)effective_date,
945: cnty.jurisdiction_code jurisdiction_code
946: FROM pay_assignment_actions paa ,
947: pay_payroll_actions ppa ,
948: pay_us_emp_county_tax_rules_f cnty ,
949: pay_us_county_tax_info_f ctif ,
950: pay_us_counties names

Line 1000: FROM pay_assignment_actions paa ,

996: , 6) ordercol2
997: , tax_type_code
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

Line 1033: FROM pay_assignment_actions paa

1029: , 6) ordercol2
1030: , tax_type_code
1031: , balance_category_code
1032: , city.jurisdiction_code
1033: FROM pay_assignment_actions paa
1034: ,pay_payroll_actions ppa
1035: ,pay_us_local_ee_wage_types_v petv
1036: ,pay_us_city_names names
1037: ,pay_us_emp_city_tax_rules_f city

Line 1074: FROM pay_assignment_actions paa

1070: , 6) ordercol2
1071: , tax_type_code
1072: , balance_category_code
1073: , cnty.jurisdiction_code
1074: FROM pay_assignment_actions paa
1075: ,pay_payroll_actions ppa
1076: ,pay_us_local_ee_wage_types_v petv
1077: ,pay_us_emp_county_tax_rules_f cnty
1078: ,pay_us_county_tax_info_f ctif

Line 1103: FROM pay_assignment_actions paa

1099: CURSOR c_local_dt12 IS
1100: SELECT DISTINCT
1101: NVL(ppa.date_earned,ppa.effective_date)effective_date,
1102: jurisdiction_code
1103: FROM pay_assignment_actions paa
1104: , pay_payroll_actions ppa
1105: , pay_us_asg_schools_v school
1106: WHERE paa.payroll_action_id = ppa.payroll_action_id
1107: AND school.assignment_id = paa.assignment_id