[Home] [Help]
2949: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
2950:
2951: CURSOR task_number_cur IS
2952: SELECT task_number
2953: FROM pa_tasks_expend_v -- Bug : 16391366 (20/03/2013)
2954: WHERE task_id = gms_interface_rec.task_id;
2955:
2956: CURSOR emp_org_name_cur IS
2957: SELECT name -- Bug 2447912: Removed SUBSTR function