APPS.AR_CMGT_AME_UTILS dependencies on AR_CMGT_CASE_FOLDERS

Line 82: l_credit_currency ar_cmgt_case_folders.limit_currency%type;

78:
79:
80: FUNCTION get_credit_limit_currency ( transactionIdIn IN NUMBER)
81: return VARCHAR2 AS
82: l_credit_currency ar_cmgt_case_folders.limit_currency%type;
83: BEGIN
84: SELECT limit_currency
85: INTO l_credit_currency
86: FROM ar_cmgt_case_folders

Line 86: FROM ar_cmgt_case_folders

82: l_credit_currency ar_cmgt_case_folders.limit_currency%type;
83: BEGIN
84: SELECT limit_currency
85: INTO l_credit_currency
86: FROM ar_cmgt_case_folders
87: WHERE case_folder_id = transactionIdIn;
88:
89:
90: return(l_credit_currency);

Line 102: l_exchange_rate_type ar_cmgt_case_folders.exchange_rate_type%type;

98: END;
99:
100: FUNCTION get_exchange_rate_type ( transactionIdIn IN NUMBER)
101: return VARCHAR2 AS
102: l_exchange_rate_type ar_cmgt_case_folders.exchange_rate_type%type;
103: BEGIN
104: SELECT exchange_rate_type
105: INTO l_exchange_rate_type
106: FROM ar_cmgt_case_folders

Line 106: FROM ar_cmgt_case_folders

102: l_exchange_rate_type ar_cmgt_case_folders.exchange_rate_type%type;
103: BEGIN
104: SELECT exchange_rate_type
105: INTO l_exchange_rate_type
106: FROM ar_cmgt_case_folders
107: WHERE case_folder_id = transactionIdIn;
108:
109: return(l_exchange_rate_type);
110:

Line 126: ar_cmgt_case_folders b

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';
130: