APPS.LNS_PARTICIPANTS_PUB dependencies on AR_CMGT_CASE_FOLDERS

Line 1374: from ar_cmgt_case_folders case, lns_participants part

1370: where loan_id = pLoanId;
1371:
1372: CURSOR check_case_folder_complete(pLoanId Number) is
1373: select count(case.case_folder_id)
1374: from ar_cmgt_case_folders case, lns_participants part
1375: where case.credit_request_id = part.credit_request_id and
1376: part.loan_id = p_loan_id and
1377: part.loan_participant_type = 'PRIMARY_BORROWER' and
1378: part.end_date_active is null and

Line 1384: FROM ar_cmgt_case_folders case_folder,lns_participants part

1380: case.status = 'CLOSED';
1381:
1382: CURSOR get_case_folder_info(pLoanId Number) is
1383: SELECT case_folder.case_folder_id,case_folder.credit_classification,part.participant_id
1384: FROM ar_cmgt_case_folders case_folder,lns_participants part
1385: WHERE case_folder.credit_request_id = part.credit_request_id
1386: AND part.loan_id = pLoanId
1387: AND type = 'CASE'
1388: AND status = 'CLOSED';

Line 1566: AR_CMGT_CASE_FOLDERS

1562: /*
1563: IF (l_credit_request_id IS NOT NULL) THEN
1564: SELECT CASE_FOLDER_ID INTO l_case_folder_id
1565: FROM
1566: AR_CMGT_CASE_FOLDERS
1567: WHERE CREDIT_REQUEST_ID = l_credit_request_id;
1568:
1569: IF (l_case_folder_id IS NOT NULL) THEN
1570: UPDATE LNS_PARTICIPANTS