APPS.AR_CMGT_AME_UTILS dependencies on AR_CMGT_CREDIT_REQUESTS

Line 121: l_amount_requested ar_cmgt_credit_requests.limit_amount%type;

117: END;
118:
119: FUNCTION get_amount_requested ( transactionIdIn IN NUMBER)
120: return NUMBER AS
121: l_amount_requested ar_cmgt_credit_requests.limit_amount%type;
122: BEGIN
123: select nvl(a.limit_amount,a.trx_amount)
124: into l_amount_requested
125: from ar_cmgt_credit_requests a,

Line 125: from ar_cmgt_credit_requests a,

121: l_amount_requested ar_cmgt_credit_requests.limit_amount%type;
122: BEGIN
123: select nvl(a.limit_amount,a.trx_amount)
124: into l_amount_requested
125: from ar_cmgt_credit_requests a,
126: ar_cmgt_case_folders b
127: WHERE b.case_folder_id = transactionIdIn
128: AND a.credit_request_id = b.credit_request_id
129: AND b.type = 'CASE';