[Home] [Help]
17: 17 May 99 Isen 115.3 Removed null others exception handler
18: - bug 2422
19: 25 May 99 Isen 115.4 Added procedure to initialize globals
20: 01 Jul 99 Asen 115.5 Added code for decode fields.
21: 14 jub 91 tilak 115.6 pay_payroll_actions.effective_Date
22: extracted for payroll end date criteria
23: 30 nov 01 tjesumic 115.7 for performance cursor changed bug 2129704
24: 14 dec 01 tjesumic 115.8 for performance cursor changed bug 2129704
25: 06 feb 02 tjesumic 115.9 comment added ,why the global assignment id is not
133: pay_element_classifications ec,
134: ff_formulas_f ff,
135: pay_run_results rr,
136: pay_run_result_values rv,
137: pay_payroll_actions ppa
138: where
139: asg.person_id = p_person_id
140: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
141: and asg.assignment_id = aac.assignment_id
163: select /*+ ordered */ aac.assignment_action_id ,
164: ppa.effective_Date effective_Date
165: from per_all_assignments_f asg,
166: pay_assignment_actions aac,
167: pay_payroll_actions ppa
168: where asg.person_id = p_person_id
169: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
170: and asg.assignment_id = aac.assignment_id
171: and aac.payroll_action_id = ppa.payroll_action_id