APPS.OCM_RECOMMENDATIONS_PUB dependencies on AR_CMGT_CASE_FOLDERS

Line 108: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

104: x_msg_data OUT NOCOPY VARCHAR2 ) IS
105:
106: l_check_rec_exists NUMBER;
107: l_credit_request_id ar_cmgt_credit_requests.credit_request_id%type;
108: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
109:
110: BEGIN
111: IF pg_debug = 'Y'
112: THEN

Line 131: FROM ar_cmgt_case_folders

127: -- check the status of the case folder. It must be closed for appealing.
128: BEGIN
129: SELECT credit_request_id, case_folder_id
130: INTO l_credit_request_id, l_case_folder_id
131: FROM ar_cmgt_case_folders
132: WHERE case_folder_id = nvl(p_case_folder_id, case_folder_id )
133: AND credit_request_id = nvl(p_credit_request_id, credit_request_id)
134: AND type = 'CASE'
135: AND status = 'CLOSED';