APPS.MSC_X_HZ_UPDATE dependencies on DUAL

Line 763: FROM DUAL;

759: BEGIN
760:
761: SELECT sys_context('MSC','COMPANY_ID'), sys_context('MSC','COMPANY_NAME')
762: INTO v_pub_id, v_pub_name
763: FROM DUAL;
764:
765: -- select the date bkts .
766: SELECT BUCKET1,nvl(BUCKET2,LAST_BUCKET),nvl(BUCKET3,LAST_BUCKET),nvl(BUCKET4,LAST_BUCKET),
767: nvl(BUCKET5,LAST_BUCKET),nvl(BUCKET6,LAST_BUCKET),nvl(BUCKET7,LAST_BUCKET),

Line 1284: FROM dual;

1280:
1281: BEGIN
1282: SELECT fnd_global.user_id
1283: INTO v_user_id
1284: FROM dual;
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: v_user_id := -1;
1288: END;