DBA Data[Home] [Help]

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on DUAL

Line 855: FROM dual;

851: l_request_id NUMBER;
852:
853: CURSOR req_id_csr IS
854: SELECT decode(fnd_global.conc_request_id, -1, NULL, fnd_global.conc_request_id)
855: FROM dual;
856:
857: ------------------------------------------------------------
858: -- Operating Unit
859: ------------------------------------------------------------

Line 1035: FROM dual;

1031: l_request_id,
1032: l_program_application_id,
1033: l_program_id,
1034: l_program_update_date
1035: FROM dual;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: Fnd_File.PUT_LINE (Fnd_File.LOG,'(Exception): When resolving request_id'||SQLERRM );
1039: END;

Line 3474: FROM dual;

3470:
3471: CURSOR req_id_csr IS
3472: SELECT
3473: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
3474: FROM dual;
3475:
3476:
3477: CURSOR xsi_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3478: SELECT COUNT(*)