DBA Data[Home] [Help]

APPS.HZP_CUST_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 510: FROM hz_cust_profile_amts

506: ) RETURN NUMBER is
507: l_overall_cr_limit NUMBER;
508: cursor c_overall IS
509: SELECT overall_credit_limit
510: FROM hz_cust_profile_amts
511: WHERE cust_account_id = p_customer_id
512: AND currency_code = p_currency_code
513: AND decode( p_customer_site_use_id,
514: NULL, -10,

Line 532: FROM hz_cust_profile_amts

528: ) RETURN NUMBER is
529: l_order_cr_limit NUMBER;
530: CURSOR c_order IS
531: SELECT trx_credit_limit
532: FROM hz_cust_profile_amts
533: WHERE cust_account_id = p_customer_id
534: AND currency_code = p_currency_code
535: AND DECODE( p_customer_site_use_id,
536: NULL, -10, p_customer_site_use_id ) =