69: cursor c_indep(pactid in number, assignid in number) is
70: select 1,
71: pa1.effective_date,
72: pa2.effective_date
73: from pay_payroll_actions pa1,
74: pay_payroll_actions pa2,
75: pay_action_classifications pcl,
76: pay_assignment_actions ac2
77: where pa1.payroll_action_id = pactid
70: select 1,
71: pa1.effective_date,
72: pa2.effective_date
73: from pay_payroll_actions pa1,
74: pay_payroll_actions pa2,
75: pay_action_classifications pcl,
76: pay_assignment_actions ac2
77: where pa1.payroll_action_id = pactid
78: and ac2.assignment_id = assignid
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,
97: pay_object_groups pog_act,
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,
97: pay_object_groups pog_act,
98: pay_object_groups pog_grp
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,
127: per_periods_of_service pos
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,
127: per_periods_of_service pos
128: where pa1.payroll_action_id = pactid
153: hr_utility.set_location('hr_pyoint.validate',2);
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