[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);