[Home] [Help]
34: ** 14-Mar-2003 srrajago 2850738 115.11 Included the join paa.period_of_service_id = pps.period_of_service_id
35: ** in the cursor csr_hire_date so as to pick up the correct hire date
36: ** incase of rehire.
37: ** 30-May-2003 kaverma 2920731 115.12 Replaced tables per_all_assignments_f and per_all_people_f by secured views
38: ** per_assignments_f and per_people_f respectively form the queries
39: ** 24-Jul-2003 srrajago 3062419 115.13 Added two variables l_fin_start_date and l_fin_end_date for storing the
40: ** financial year start and end date respectively. p_periods value ( end_date
41: ** value only) modified so that it returns different values for IR56B and
42: ** IR56F and IR56G.
122: IS
123: SELECT pps.date_start,
124: pps.actual_termination_date
125: FROM per_periods_of_service pps,
126: per_people_f ppf,
127: per_assignments_f paf
128: WHERE paf.person_id = ppf.person_id
129: AND pps.person_id = paf.person_id
130: AND paf.assignment_id = p_assignment_id