APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 381: FROM pay_assignment_actions paa

377: CURSOR c_state_dt IS
378: SELECT DISTINCT
379: NVL(ppa.date_earned,ppa.effective_date)effective_date,
380: jurisdiction_code
381: FROM pay_assignment_actions paa
382: ,pay_us_emp_state_tax_rules_f pue
383: ,pay_payroll_actions ppa
384: WHERE paa.assignment_action_id = p_asact_id
385: AND pue.assignment_id = paa.assignment_id

Line 416: FROM pay_assignment_actions paa

412: , 6) ordercol2
413: , tax_type_code
414: , balance_category_code
415: , jurisdiction_code
416: FROM pay_assignment_actions paa
417: ,pay_payroll_actions ppa
418: ,pay_us_state_tax_types_v pstt
419: ,pay_us_emp_state_tax_rules_f pue
420: WHERE paa.assignment_action_id = p_asact_id

Line 491: FROM pay_assignment_actions paa

487: , 6) ordercol2
488: , tax_type_code
489: , balance_category_code
490: , jurisdiction_code
491: FROM pay_assignment_actions paa
492: ,pay_payroll_actions ppa
493: ,pay_us_state_liability_types_v pstt
494: ,pay_us_emp_state_tax_rules_f pue
495: WHERE paa.assignment_action_id = p_asact_id

Line 531: FROM pay_assignment_actions paa

527: , 6) ordercol2
528: , tax_type_code
529: , balance_category_code
530: , jurisdiction_code
531: FROM pay_assignment_actions paa
532: ,pay_payroll_actions ppa
533: ,pay_us_state_er_wage_types_v pstt
534: ,pay_us_emp_state_tax_rules_f pue
535: WHERE pue.assignment_id = paa.assignment_id

Line 741: pay_assignment_actions paa ,

737: , tax_type_code
738: , balance_category_code
739: , city.jurisdiction_code
740: FROM
741: pay_assignment_actions paa ,
742: pay_payroll_actions ppa ,
743: pay_us_local_tax_types_v petv ,
744: pay_us_emp_city_tax_rules_f city ,
745: pay_us_city_names names ,

Line 776: pay_assignment_actions paa ,

772: SELECT DISTINCT
773: NVL(ppa.date_earned,ppa.effective_date)effective_date,
774: cnty.jurisdiction_code jurisdiction_code
775: FROM
776: pay_assignment_actions paa ,
777: pay_payroll_actions ppa ,
778: pay_us_emp_county_tax_rules_f cnty ,
779: pay_us_county_tax_info_f ctif ,
780: pay_us_counties names

Line 827: FROM pay_assignment_actions paa ,

823: CURSOR c_local_dt3 IS
824: SELECT DISTINCT
825: NVL(ppa.date_earned,ppa.effective_date)effective_date,
826: jurisdiction_code
827: FROM pay_assignment_actions paa ,
828: pay_payroll_actions ppa ,
829: pay_us_asg_schools_v school
830: WHERE paa.payroll_action_id = ppa.payroll_action_id
831: AND school.assignment_id = paa.assignment_id

Line 887: FROM pay_assignment_actions paa

883: , 6) ordercol2
884: , tax_type_code
885: , balance_category_code
886: , city.jurisdiction_code
887: FROM pay_assignment_actions paa
888: ,pay_payroll_actions ppa
889: ,pay_us_local_ee_wage_types_v petv
890: ,pay_us_city_names names
891: ,pay_us_emp_city_tax_rules_f city

Line 933: FROM pay_assignment_actions paa

929: , 6) ordercol2
930: , tax_type_code
931: , balance_category_code
932: , cnty.jurisdiction_code
933: FROM pay_assignment_actions paa
934: ,pay_payroll_actions ppa
935: ,pay_us_local_ee_wage_types_v petv
936: ,pay_us_emp_county_tax_rules_f cnty
937: ,pay_us_county_tax_info_f ctif

Line 963: FROM pay_assignment_actions paa

959: CURSOR c_local_dt6 IS
960: SELECT DISTINCT
961: NVL(ppa.date_earned,ppa.effective_date)effective_date,
962: jurisdiction_code
963: FROM pay_assignment_actions paa
964: , pay_payroll_actions ppa
965: , pay_us_asg_schools_v school
966: WHERE paa.payroll_action_id = ppa.payroll_action_id
967: AND school.assignment_id = paa.assignment_id

Line 1018: FROM pay_assignment_actions paa ,

1014: , 6) ordercol2
1015: , tax_type_code
1016: , balance_category_code
1017: , city.jurisdiction_code
1018: FROM pay_assignment_actions paa ,
1019: pay_payroll_actions ppa ,
1020: pay_us_local_tax_types_v petv ,
1021: pay_us_emp_city_tax_rules_f city ,
1022: pay_us_city_names names ,

Line 1049: FROM pay_assignment_actions paa ,

1045: CURSOR c_local_dt8 IS
1046: SELECT DISTINCT
1047: NVL(ppa.date_earned,ppa.effective_date)effective_date,
1048: cnty.jurisdiction_code jurisdiction_code
1049: FROM pay_assignment_actions paa ,
1050: pay_payroll_actions ppa ,
1051: pay_us_emp_county_tax_rules_f cnty ,
1052: pay_us_county_tax_info_f ctif ,
1053: pay_us_counties names

Line 1103: FROM pay_assignment_actions paa ,

1099: , 6) ordercol2
1100: , tax_type_code
1101: , balance_category_code
1102: , jurisdiction_code
1103: FROM pay_assignment_actions paa ,
1104: pay_payroll_actions ppa ,
1105: pay_us_local_tax_types_v petv ,
1106: pay_us_asg_schools_v school
1107: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 1136: FROM pay_assignment_actions paa

1132: , 6) ordercol2
1133: , tax_type_code
1134: , balance_category_code
1135: , city.jurisdiction_code
1136: FROM pay_assignment_actions paa
1137: ,pay_payroll_actions ppa
1138: ,pay_us_local_ee_wage_types_v petv
1139: ,pay_us_city_names names
1140: ,pay_us_emp_city_tax_rules_f city

Line 1177: FROM pay_assignment_actions paa

1173: , 6) ordercol2
1174: , tax_type_code
1175: , balance_category_code
1176: , cnty.jurisdiction_code
1177: FROM pay_assignment_actions paa
1178: ,pay_payroll_actions ppa
1179: ,pay_us_local_ee_wage_types_v petv
1180: ,pay_us_emp_county_tax_rules_f cnty
1181: ,pay_us_county_tax_info_f ctif

Line 1206: FROM pay_assignment_actions paa

1202: CURSOR c_local_dt12 IS
1203: SELECT DISTINCT
1204: NVL(ppa.date_earned,ppa.effective_date)effective_date,
1205: jurisdiction_code
1206: FROM pay_assignment_actions paa
1207: , pay_payroll_actions ppa
1208: , pay_us_asg_schools_v school
1209: WHERE paa.payroll_action_id = ppa.payroll_action_id
1210: AND school.assignment_id = paa.assignment_id