DBA Data[Home] [Help]

APPS.IGI_IAC_BOOK_CONTROLS_PKG dependencies on DUAL

Line 502: NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ('CLIENT_INFO' ), 1, 1 ), ' ', NULL, SUBSTRB (USERENV ('CLIENT_INFO'),1,10) ) ), NULL ) org_id FROM dual;

498: CURSOR cur_orgid IS
499:
500: SELECT
501:
502: NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ('CLIENT_INFO' ), 1, 1 ), ' ', NULL, SUBSTRB (USERENV ('CLIENT_INFO'),1,10) ) ), NULL ) org_id FROM dual;
503:
504:
505:
506: lv_org_id Number(15);