APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_ASG_SCHOOLS_V

Line 829: pay_us_asg_schools_v school

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
833: AND ppa.action_type in ('Q', 'R', 'V', 'I', 'B')

Line 965: , pay_us_asg_schools_v school

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
969: AND ppa.action_type in ('Q', 'R', 'V', 'I', 'B')

Line 1106: pay_us_asg_schools_v school

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
1109: AND school.tax_unit_id = paa.tax_unit_id
1110: AND ppa.action_type in ('Q', 'R', 'V', 'I', 'B')

Line 1208: , pay_us_asg_schools_v school

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
1212: AND ppa.action_type in ('Q', 'R', 'V', 'I', 'B')