DBA Data[Home] [Help]

APPS.ONT_OEXOECCH_XMLP_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 347: HZ_CUST_PROFILE_AMTS CPA

343: ,-1)
344: INTO L_TOTAL_LIMIT,L_ORDER_LIMIT
345: FROM
346: HZ_CUSTOMER_PROFILES CP,
347: HZ_CUST_PROFILE_AMTS CPA
348: WHERE CP.SITE_USE_ID = C_COMPUTE_AMOUNTSFORMULA.SITE_USE_ID
349: AND CP.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
350: AND CPA.CURRENCY_CODE = CURRENCY1;
351: ELSE

Line 363: HZ_CUST_PROFILE_AMTS CPA

359: ,-1)
360: INTO L_TOTAL_LIMIT,L_ORDER_LIMIT
361: FROM
362: HZ_CUSTOMER_PROFILES CP,
363: HZ_CUST_PROFILE_AMTS CPA
364: WHERE CP.CUST_ACCOUNT_ID = CUSTOMER_ID
365: AND CP.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
366: AND CPA.CURRENCY_CODE = CURRENCY1
367: AND CP.SITE_USE_ID IS NULL;