9351: l_prev_prog_upd_date date; -- 7225884
9352:
9353: cursor l_cur_publish(l_request_id NUMBER) is
9354: select substr(fcrsv.argument_text,1,(instr(fcrsv.argument_text,','))-1) process
9355: from fnd_conc_req_summary_v fcrsv
9356: where fcrsv.request_id = l_request_id;
9357:
9358: l_rec_publish l_cur_publish%ROWTYPE;
9359:
22701: -- Begin fix for Bug # 4524977.
22702:
22703: cursor l_cur_publish(l_request_id NUMBER) is
22704: select substr(fcrsv.argument_text,1,(instr(fcrsv.argument_text,','))-1) process
22705: from fnd_conc_req_summary_v fcrsv
22706: where fcrsv.request_id = l_request_id;
22707:
22708: l_rec_publish l_cur_publish%ROWTYPE;
22709: