APPS.HR_PYOINT dependencies on PER_ASSIGNMENTS_F

Line 92: from per_assignments_f as1,

88: select 1,
89: pa1.effective_date,
90: pa2.effective_date,
91: as1.assignment_number
92: from per_assignments_f as1,
93: pay_payroll_actions pa1,
94: pay_payroll_actions pa2,
95: pay_action_classifications pcl,
96: pay_assignment_actions ac2,

Line 121: from per_assignments_f as1,

117: select 1,
118: pa1.effective_date,
119: pa2.effective_date,
120: as1.assignment_number
121: from per_assignments_f as1,
122: per_assignments_f as2,
123: pay_payroll_actions pa1,
124: pay_payroll_actions pa2,
125: pay_action_classifications pcl,

Line 122: per_assignments_f as2,

118: pa1.effective_date,
119: pa2.effective_date,
120: as1.assignment_number
121: from per_assignments_f as1,
122: per_assignments_f as2,
123: pay_payroll_actions pa1,
124: pay_payroll_actions pa2,
125: pay_action_classifications pcl,
126: pay_assignment_actions ac2,

Line 151: -- Get the assignment_number (note: per_assignments_f is

147: hr_utility.set_location('hr_pyoint.validate',1);
148: open c_indep(pactid,assignid);
149: fetch c_indep into failed, ed1, ed2;
150:
151: -- Get the assignment_number (note: per_assignments_f is
152: -- datetracked).
153: hr_utility.set_location('hr_pyoint.validate',2);
154: if(not c_indep%NOTFOUND) then
155: select ass.assignment_number

Line 158: per_assignments_f ass

154: if(not c_indep%NOTFOUND) then
155: select ass.assignment_number
156: into assnum
157: from pay_payroll_actions ppa,
158: per_assignments_f ass
159: where ppa.payroll_action_id = pactid
160: and ass.assignment_id = assignid
161: and ass.payroll_id = ppa.payroll_id
162: and (ppa.effective_date between