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,
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 ) =