APPS.AR_CMGT_AME_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

    SELECT recommendation_value2
    INTO   l_credit_limit
    FROM   ar_cmgt_cf_recommends
    WHERE  case_folder_id = transactionIdIn
    AND    credit_recommendation = 'CREDIT_LIMIT';

Line: 27

    SELECT recommendation_value2
    INTO   l_credit_limit
    FROM   ar_cmgt_cf_recommends
    WHERE  case_folder_id = transactionIdIn
    AND    credit_recommendation = 'TXN_CREDIT_LIMIT';

Line: 46

    SELECT SUM(SCORE)
    INTO   l_score
    FROM   ar_cmgt_cf_dtls
    WHERE  case_folder_id = transactionIdIn;

Line: 64

    SELECT recommendation_value1
    INTO   l_credit_classification
    FROM   ar_cmgt_cf_recommends
    WHERE  case_folder_id = transactionIdIn
    AND    credit_recommendation = 'CLASSIFICATION';

Line: 84

    SELECT limit_currency
    INTO   l_credit_currency
    FROM   ar_cmgt_case_folders
    WHERE  case_folder_id = transactionIdIn;

Line: 104

    SELECT exchange_rate_type
    INTO   l_exchange_rate_type
    FROM   ar_cmgt_case_folders
    WHERE  case_folder_id = transactionIdIn;

Line: 123

    select nvl(a.limit_amount,a.trx_amount)
    into   l_amount_requested
    from ar_cmgt_credit_requests a,
         ar_cmgt_case_folders b
    WHERE b.case_folder_id = transactionIdIn
    AND   a.credit_request_id = b.credit_request_id
    AND   b.type = 'CASE';