APPS.BIM_CAMPAIGN_FACTS dependencies on DUAL

Line 521: FROM dual;

517: l_org_id number;
518:
519: CURSOR get_org_id IS
520: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
521: FROM dual;
522: l_status1 VARCHAR2(5);
523: l_industry1 VARCHAR2(5);
524: l_schema VARCHAR2(30);
525: l_return BOOLEAN;

Line 2721: FROM dual;

2717: l_org_id number;
2718:
2719: CURSOR get_org_id IS
2720: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))
2721: FROM dual;
2722:
2723: l_camp number;
2724: l_schema VARCHAR2(30);
2725: l_status1 VARCHAR2(5);