APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 280: ,pay_payroll_actions ppa

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

Line 314: ,pay_payroll_actions ppa

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

Line 389: ,pay_payroll_actions ppa

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

Line 429: ,pay_payroll_actions ppa

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

Line 639: pay_payroll_actions ppa ,

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

Line 674: pay_payroll_actions ppa ,

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

Line 725: pay_payroll_actions ppa ,

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

Line 785: ,pay_payroll_actions ppa

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

Line 831: ,pay_payroll_actions ppa

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

Line 861: , pay_payroll_actions ppa

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

Line 916: pay_payroll_actions ppa ,

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

Line 947: pay_payroll_actions ppa ,

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

Line 1001: pay_payroll_actions ppa ,

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

Line 1034: ,pay_payroll_actions ppa

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

Line 1075: ,pay_payroll_actions ppa

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

Line 1104: , pay_payroll_actions ppa

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