APPS.PAY_ARCHIVE_MISSING_ASG_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 44: FROM per_all_assignments_f ASG,

40: from pay_payroll_actions
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(

Line 84: FROM per_all_assignments_f paf,

80: ) is
81:
82: SELECT distinct paf.assignment_id asg_id,
83: paa.assignment_action_id assact
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

Line 132: FROM per_all_assignments_f paf,

128: ) is
129:
130: SELECT distinct paf.assignment_id asg_id,
131: paa.assignment_action_id assact
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,