APPS.PAY_US_TAX_BAL_SUMMARY_PKG dependencies on PAY_US_ASG_SCHOOLS_V

Line 726: pay_us_asg_schools_v school

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

Line 862: , pay_us_asg_schools_v school

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

Line 1003: pay_us_asg_schools_v school

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

Line 1105: , pay_us_asg_schools_v school

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