274:
275: CURSOR c_ids
276: IS
277: SELECT irs.ind_rate_sch_id
278: FROM pa_lookups l, pa_ind_rate_schedules irs
279: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
280: AND l.lookup_code = irs.ind_rate_schedule_type
281: AND irs.project_id IS NULL
282: AND trunc(sysdate) BETWEEN irs.start_date_active
289: IF p_check_id_flag = 'Y'
290: THEN
291: SELECT irs.ind_rate_sch_id
292: INTO x_rev_sch_id
293: FROM pa_lookups l, pa_ind_rate_schedules irs
294: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
295: AND l.lookup_code = irs.ind_rate_schedule_type
296: AND irs.project_id IS NULL
297: AND trunc(sysdate) BETWEEN irs.start_date_active
336: IF p_rev_sch_name IS NOT NULL
337: THEN
338: SELECT irs.ind_rate_sch_id
339: INTO x_rev_sch_id
340: FROM pa_lookups l, pa_ind_rate_schedules irs
341: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
342: AND l.lookup_code = irs.ind_rate_schedule_type
343: AND irs.project_id IS NULL
344: AND trunc(sysdate) BETWEEN irs.start_date_active
398:
399: CURSOR c_ids
400: IS
401: SELECT irs.ind_rate_sch_id
402: FROM pa_lookups l, pa_ind_rate_schedules irs
403: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
404: AND l.lookup_code = irs.ind_rate_schedule_type
405: AND irs.project_id IS NULL
406: AND trunc(sysdate) BETWEEN irs.start_date_active
413: IF p_check_id_flag = 'Y'
414: THEN
415: SELECT irs.ind_rate_sch_id
416: INTO x_inv_sch_id
417: FROM pa_lookups l, pa_ind_rate_schedules irs
418: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
419: AND l.lookup_code = irs.ind_rate_schedule_type
420: AND irs.project_id IS NULL
421: AND trunc(sysdate) BETWEEN irs.start_date_active
460: IF p_inv_sch_name IS NOT NULL
461: THEN
462: SELECT irs.ind_rate_sch_id
463: INTO x_inv_sch_id
464: FROM pa_lookups l, pa_ind_rate_schedules irs
465: WHERE l.lookup_type = 'IND RATE SCHEDULE TYPE'
466: AND l.lookup_code = irs.ind_rate_schedule_type
467: AND irs.project_id IS NULL
468: AND trunc(sysdate) BETWEEN irs.start_date_active