APPS.LNS_PARTICIPANTS_PUB dependencies on AR_CMGT_CASE_FOLDERS

Line 1372: from ar_cmgt_case_folders case, lns_participants part

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

Line 1382: FROM ar_cmgt_case_folders case_folder,lns_participants part

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

Line 1564: AR_CMGT_CASE_FOLDERS

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