APPS.OCM_GET_EXTRL_DECSN_PUB dependencies on AR_CMGT_CREDIT_REQUESTS

Line 306: l_credit_type ar_cmgt_credit_requests.credit_type%type;

302: ) IS
303: l_case_folder_type ar_cmgt_case_folders.type%type;
304: l_case_folder_status ar_cmgt_case_folders.status%type;
305: l_credit_request_id ar_cmgt_case_folders.credit_request_id%type;
306: l_credit_type ar_cmgt_credit_requests.credit_type%type;
307: l_lookup_type fnd_lookups.lookup_type%type;
308: l_application_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
309:
310: BEGIN

Line 308: l_application_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;

304: l_case_folder_status ar_cmgt_case_folders.status%type;
305: l_credit_request_id ar_cmgt_case_folders.credit_request_id%type;
306: l_credit_type ar_cmgt_credit_requests.credit_type%type;
307: l_lookup_type fnd_lookups.lookup_type%type;
308: l_application_id ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID%type;
309:
310: BEGIN
311: /* The following validation will be placed into the API
312: 1. Case folder Id must be of typed 'CASE'.

Line 337: ar_cmgt_credit_requests.credit_type,

333: BEGIN
334: select ar_cmgt_case_folders.type,
335: ar_cmgt_case_folders.status,
336: ar_cmgt_case_folders.credit_request_id,
337: ar_cmgt_credit_requests.credit_type,
338: ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID
339: into l_case_folder_type,
340: l_case_folder_status,
341: l_credit_request_id,

Line 338: ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID

334: select ar_cmgt_case_folders.type,
335: ar_cmgt_case_folders.status,
336: ar_cmgt_case_folders.credit_request_id,
337: ar_cmgt_credit_requests.credit_type,
338: ar_cmgt_credit_requests.SOURCE_RESP_APPLN_ID
339: into l_case_folder_type,
340: l_case_folder_status,
341: l_credit_request_id,
342: l_credit_type,

Line 345: ar_cmgt_credit_requests

341: l_credit_request_id,
342: l_credit_type,
343: l_application_id
344: from ar_cmgt_case_folders,
345: ar_cmgt_credit_requests
346: where ar_cmgt_case_folders.case_folder_id = p_case_folder_id ;
347:
348: IF l_case_folder_type = 'CASE' and
349: ((l_case_folder_status = 'CREATED') or (l_case_folder_status = 'SAVED')