APPS.AR_CMGT_UTIL dependencies on AR_CMGT_CASE_FOLDERS

Line 408: FROM AR_CMGT_CASE_FOLDERS

404: RETURN NUMBER IS
405:
406: CURSOR latest_cf_number(p_credit_request_id IN NUMBER ) IS
407: SELECT case_folder_number
408: FROM AR_CMGT_CASE_FOLDERS
409: WHERE credit_request_id = p_credit_request_id;
410:
411: l_case_folder_number NUMBER;
412:

Line 794: l_resource_id ar_cmgt_case_folders.credit_analyst_id%type;

790: END;
791:
792: FUNCTION get_person_based_on_cf ( l_case_folder_id IN NUMBER)
793: return NUMBER IS
794: l_resource_id ar_cmgt_case_folders.credit_analyst_id%type;
795: l_person_id per_people_f.person_id%type;
796: CURSOR c_res_id IS
797: SELECT credit_analyst_id
798: FROM ar_cmgt_case_folders

Line 798: FROM ar_cmgt_case_folders

794: l_resource_id ar_cmgt_case_folders.credit_analyst_id%type;
795: l_person_id per_people_f.person_id%type;
796: CURSOR c_res_id IS
797: SELECT credit_analyst_id
798: FROM ar_cmgt_case_folders
799: WHERE case_folder_id = l_case_folder_id;
800:
801: BEGIN
802:

Line 829: from ar_cmgt_case_folders

825: CURSOR case_folder_exists IS
826: select 'Y'
827: from dual
828: where exists (select case_folder_id
829: from ar_cmgt_case_folders
830: where party_id = p_party_id
831: and cust_account_id = nvl(p_cust_account_id,-99)
832: and site_use_id = nvl(p_cust_account_site_id,-99));
833: