APPS.IBE_CUSTOMER_ACCT_PVT dependencies on DUAL

Line 29: SELECT NVL(TO_NUMBER(DECODE(l_orgId1,' ',NULL,l_orgId2)),-99) orgId from dual;

25: l_api_name VARCHAR2(30) := 'CUSTACCT_GETPARTYSITEID';
26:
27: CURSOR c_getOrgId
28: IS
29: SELECT NVL(TO_NUMBER(DECODE(l_orgId1,' ',NULL,l_orgId2)),-99) orgId from dual;
30:
31: l_orgId NUMBER;
32:
33: -- 4922991. CHECK FOR HZ_CUST_SITE_USES.STATUS='I' MAY NOT BE CORRECT IN SOME CASES