[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.
131: IS
132: SELECT pps.date_start,
133: pps.actual_termination_date
134: FROM per_periods_of_service pps,
135: per_people_f ppf,
136: per_assignments_f paf
137: WHERE paf.person_id = ppf.person_id
138: AND pps.person_id = paf.person_id
139: AND paf.assignment_id = p_assignment_id