APPS.PAY_ARCHIVE_MISSING_ASG_PKG dependencies on PAY_US_ASG_REPORTING

Line 45: pay_us_asg_reporting PUAR,

41: where payroll_action_id = pactid;
42:
43: sqlstr := 'SELECT distinct ASG.person_id
44: FROM per_all_assignments_f ASG,
45: pay_us_asg_reporting PUAR,
46: pay_payroll_actions PPA
47: WHERE PPA.payroll_action_id = :payroll_action_id
48: AND PUAR.tax_unit_id = pay_us_payroll_utils.get_parameter(
49: ''TRANSFER_GRE'',

Line 88: pay_us_asg_reporting puar

84: FROM per_all_assignments_f paf,
85: pay_assignment_actions paa,
86: pay_payroll_actions ppa,
87: pay_payrolls_f ppf,
88: pay_us_asg_reporting puar
89: WHERE paf.assignment_id = paa.assignment_id
90: AND paf.assignment_id = puar.assignment_id
91: AND puar.tax_unit_id = cp_tax_unit_id
92: AND paf.assignment_type = 'E'

Line 136: pay_us_asg_reporting puar,

132: FROM per_all_assignments_f paf,
133: pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_payrolls_f ppf,
136: pay_us_asg_reporting puar,
137: pay_population_ranges ppr
138: WHERE paf.assignment_id = paa.assignment_id
139: AND paf.assignment_id = puar.assignment_id
140: AND puar.tax_unit_id = cp_tax_unit_id