DBA Data[Home] [Help]

APPS.BIM_I_LEAD_FACTS_PKG dependencies on DUAL

Line 311: FROM dual;

307: l_org_id number;
308:
309: CURSOR get_org_id IS
310: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
311: FROM dual;
312: l_sysdate date;
313:
314: BEGIN
315:

Line 866: FROM dual;

862: l_org_id number;
863:
864: CURSOR get_org_id IS
865: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
866: FROM dual;
867:
868: l_status VARCHAR2(5);
869: l_industry VARCHAR2(5);
870: l_schema VARCHAR2(30);