35: WHERE pa_request_id = p_pa_request_id;
36:
37: CURSOR cur_rem_code(c_effective_date ghr_pa_requests.effective_date%type) IS
38: SELECT remark_id 39: FROM ghr_remarks 40: WHERE code = 'M67'
41: AND enabled_flag = 'Y'
42: AND nvl(c_effective_date,trunc(sysdate))
43: BETWEEN date_from AND nvl(date_to,nvl(c_effective_date, trunc(sysdate)));