DBA Data[Home] [Help]

APPS.ONT_OEXOECCH_XMLP_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 346: HZ_CUSTOMER_PROFILES CP,

342: ,-1) * (100 + CP.TOLERANCE) / 100)
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;

Line 362: HZ_CUSTOMER_PROFILES CP,

358: ,-1) * (100 + CP.TOLERANCE) / 100)
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