APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 383: ,pay_payroll_actions ppa

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
386: AND ppa.payroll_action_id = paa.payroll_action_id
387: AND ppa.effective_date between pue.effective_start_date

Line 417: ,pay_payroll_actions ppa

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
421: AND pue.assignment_id = paa.assignment_id

Line 492: ,pay_payroll_actions ppa

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
496: AND pue.assignment_id = paa.assignment_id

Line 532: ,pay_payroll_actions ppa

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
536: AND ppa.payroll_action_id = paa.payroll_action_id

Line 742: pay_payroll_actions ppa ,

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 ,
746: pay_us_city_tax_info_f citf

Line 777: pay_payroll_actions ppa ,

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
781: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 828: pay_payroll_actions ppa ,

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
832: AND school.tax_unit_id = paa.tax_unit_id

Line 888: ,pay_payroll_actions ppa

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
892: ,pay_us_city_tax_info_f citf

Line 934: ,pay_payroll_actions ppa

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
938: ,pay_us_counties names

Line 964: , pay_payroll_actions ppa

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
968: AND school.tax_unit_id = paa.tax_unit_id

Line 1019: pay_payroll_actions ppa ,

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 ,
1023: pay_us_city_tax_info_f citf

Line 1050: pay_payroll_actions ppa ,

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
1054: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 1104: pay_payroll_actions ppa ,

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
1108: AND school.assignment_id = paa.assignment_id

Line 1137: ,pay_payroll_actions ppa

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
1141: ,pay_us_city_tax_info_f citf

Line 1178: ,pay_payroll_actions ppa

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
1182: ,pay_us_counties names

Line 1207: , pay_payroll_actions ppa

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
1211: AND school.tax_unit_id = paa.tax_unit_id