APPS.AR_CMGT_UTIL dependencies on AR_CMGT_CREDIT_REQUESTS

Line 570: l_limit_currency_code ar_cmgt_credit_requests.limit_currency%type;

566: ) IS
567:
568: l_entity_type VARCHAR2(30);
569: l_entity_id NUMBER(15);
570: l_limit_currency_code ar_cmgt_credit_requests.limit_currency%type;
571: l_analysis_level VARCHAR2(1);
572:
573: BEGIN
574: l_analysis_level := AR_CMGT_UTIL.find_analysis_level(p_party_id,

Line 868: FROM ar_cmgt_credit_requests

864:
865: BEGIN
866: SELECT credit_request_id
867: INTO l_credit_request_id
868: FROM ar_cmgt_credit_requests
869: WHERE party_id = p_party_id
870: AND cust_account_id = p_cust_account_id
871: AND site_use_id = p_site_use_id
872: AND status <> 'PROCESSED';

Line 912: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;

908: FUNCTION get_credit_classification(p_party_id IN NUMBER,
909: p_cust_account_id IN NUMBER,
910: p_site_use_id IN NUMBER)
911: RETURN VARCHAR2 IS
912: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
913: l_sql_statement VARCHAR2(2000);
914:
915: BEGIN
916: