APPS.ARCM_EXTRACT_XML_CF dependencies on AR_CMGT_CASE_FOLDERS

Line 113: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;

109: l_list WF_PARAMETER_LIST_T;
110: l_param WF_PARAMETER_T;
111: l_key VARCHAR2(240);
112: l_event_name VARCHAR2(240) := 'oracle.apps.ar.cmgt.CaseFolder.extract';
113: l_case_folder_id ar_cmgt_case_folders.case_folder_id%type;
114: l_credit_request_id NUMBER;
115: l_source_name AR_CMGT_CREDIT_REQUESTS.source_name%TYPE;
116: l_source_column1 AR_CMGT_CREDIT_REQUESTS.source_column1%TYPE;
117: l_source_column2 AR_CMGT_CREDIT_REQUESTS.source_column2%TYPE;

Line 135: ar_cmgt_case_folders cf

131: cr.source_resp_appln_id,
132: cr.source_security_group_id,
133: cr.source_org_id
134: FROM ar_cmgt_credit_requests cr,
135: ar_cmgt_case_folders cf
136: WHERE case_folder_id = P_CASE_FOLDER_ID
137: AND cr.credit_request_id = cf.credit_request_id;
138:
139: BEGIN

Line 302: from AR_CMGT_CASE_FOLDERS

298: Begin
299:
300: Select 'Y'
301: INTO L_COUNT
302: from AR_CMGT_CASE_FOLDERS
303: WHERE CASE_FOLDER_ID = P_CASE_FOLDER_ID;
304: EXCEPTION
305: WHEN NO_DATA_FOUND THEN
306: RETCODE := 1;