APPS.OKL_LEASE_APP_PVT dependencies on AR_CMGT_CF_RECOMMENDS

Line 225: l_cr_recom AR_CMGT_CF_RECOMMENDS.CREDIT_RECOMMENDATION%TYPE;

221: RETURN VARCHAR2
222: IS
223: --Local variables
224: l_cr_decision VARCHAR2(50);
225: l_cr_recom AR_CMGT_CF_RECOMMENDS.CREDIT_RECOMMENDATION%TYPE;
226: l_cr_status AR_CMGT_CF_RECOMMENDS.STATUS%TYPE;
227:
228: --Cursor to check for Approve or Reject recommendation for a
229: --given Lease Application

Line 226: l_cr_status AR_CMGT_CF_RECOMMENDS.STATUS%TYPE;

222: IS
223: --Local variables
224: l_cr_decision VARCHAR2(50);
225: l_cr_recom AR_CMGT_CF_RECOMMENDS.CREDIT_RECOMMENDATION%TYPE;
226: l_cr_status AR_CMGT_CF_RECOMMENDS.STATUS%TYPE;
227:
228: --Cursor to check for Approve or Reject recommendation for a
229: --given Lease Application
230: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS

Line 233: FROM AR_CMGT_CF_RECOMMENDS RCM

229: --given Lease Application
230: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
231: SELECT RCM.CREDIT_RECOMMENDATION
232: , RCM.STATUS
233: FROM AR_CMGT_CF_RECOMMENDS RCM
234: , AR_CMGT_CREDIT_REQUESTS CCR
235: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
236: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
237: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 331: FROM AR_CMGT_CF_RECOMMENDS RCM

327: --Cursor to check for Approve or Reject recommendation for a
328: --given Lease Application
329: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
330: SELECT COUNT(*)
331: FROM AR_CMGT_CF_RECOMMENDS RCM
332: , AR_CMGT_CREDIT_REQUESTS CCR
333: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
334: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
335: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 426: FROM AR_CMGT_CF_RECOMMENDS RCM

422: --given Lease Application
423: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
424: SELECT RCM.CREDIT_RECOMMENDATION
425: , RCM.APPEALED_FLAG
426: FROM AR_CMGT_CF_RECOMMENDS RCM
427: , AR_CMGT_CREDIT_REQUESTS CCR
428: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
429: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
430: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 491: FROM AR_CMGT_CF_RECOMMENDS RCM

487: --Cursor to check for Approve or Reject recommendation for a
488: --given Lease Application
489: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
490: SELECT COUNT(*)
491: FROM AR_CMGT_CF_RECOMMENDS RCM
492: , AR_CMGT_CREDIT_REQUESTS CCR
493: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
494: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
495: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 503: FROM AR_CMGT_CF_RECOMMENDS RCM

499: --given Lease Application
500: CURSOR appeal_flag_csr(p_lap_id NUMBER)
501: IS
502: SELECT RCM.APPEALED_FLAG
503: FROM AR_CMGT_CF_RECOMMENDS RCM
504: , AR_CMGT_CREDIT_REQUESTS CCR
505: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
506: AND RCM.CREDIT_RECOMMENDATION = 'EXPIRATION_DATE'
507: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 6606: FROM AR_CMGT_CF_RECOMMENDS RCM

6602:
6603: --Cursor to check whether a given recommendation is added to given Lease App
6604: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2, p_appeal VARCHAR2) IS
6605: SELECT COUNT(*)
6606: FROM AR_CMGT_CF_RECOMMENDS RCM
6607: , AR_CMGT_CREDIT_REQUESTS CCR
6608: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
6609: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6610: AND RCM.CREDIT_RECOMMENDATION = NVL(p_recomm, RCM.CREDIT_RECOMMENDATION)

Line 6620: , AR_CMGT_CF_RECOMMENDS RCM

6616: IS
6617: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
6618: FROM AR_CMGT_CASE_FOLDERS CCF
6619: , AR_CMGT_CREDIT_REQUESTS CCR
6620: , AR_CMGT_CF_RECOMMENDS RCM
6621: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
6622: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6623: AND CCF.STATUS = 'CLOSED'
6624: AND RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID

Line 8151: FROM AR_CMGT_CF_RECOMMENDS RCM

8147: --Bug 4753078 Cursor to check for Approve or Reject recommendation for a
8148: --given Lease Application
8149: CURSOR credit_recom_csr(cp_lap_id NUMBER, p_recom VARCHAR2) IS
8150: SELECT COUNT(*)
8151: FROM AR_CMGT_CF_RECOMMENDS RCM
8152: , AR_CMGT_CREDIT_REQUESTS CCR
8153: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8154: AND RCM.CREDIT_RECOMMENDATION = p_recom
8155: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 8174: FROM AR_CMGT_CF_RECOMMENDS CCRM

8170: --Lease App
8171: CURSOR ocm_counter_offer_csr(cp_lap_id NUMBER, cp_co_id NUMBER)
8172: IS
8173: SELECT 'X'
8174: FROM AR_CMGT_CF_RECOMMENDS CCRM
8175: , AR_CMGT_CREDIT_REQUESTS CCR
8176: WHERE CCRM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8177: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
8178: AND CCRM.CREDIT_RECOMMENDATION = 'COUNTER_OFFER'

Line 9759: FROM AR_CMGT_CF_RECOMMENDS RCM

9755:
9756: --Cursor to check whether a given recommendation is added to given Lease App
9757: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2) IS
9758: SELECT COUNT(*)
9759: FROM AR_CMGT_CF_RECOMMENDS RCM
9760: , AR_CMGT_CREDIT_REQUESTS CCR
9761: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
9762: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9763: AND RCM.CREDIT_RECOMMENDATION = p_recomm

Line 9772: , AR_CMGT_CF_RECOMMENDS RCM

9768: IS
9769: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
9770: FROM AR_CMGT_CASE_FOLDERS CCF
9771: , AR_CMGT_CREDIT_REQUESTS CCR
9772: , AR_CMGT_CF_RECOMMENDS RCM
9773: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
9774: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9775: AND CCF.STATUS = 'CLOSED'
9776: AND RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID

Line 11453: FROM AR_CMGT_CF_RECOMMENDS RCM

11449: , RCM.CREDIT_REQUEST_ID
11450: , RCM.CREDIT_RECOMMENDATION
11451: , RCM.RECOMMENDATION_NAME
11452: , RCM.APPEALED_FLAG
11453: FROM AR_CMGT_CF_RECOMMENDS RCM
11454: , AR_CMGT_CREDIT_REQUESTS CCR
11455: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
11456: AND RCM.CREDIT_RECOMMENDATION = NVL(cp_cr_recom, RCM.CREDIT_RECOMMENDATION)
11457: AND RCM.RECOMMENDATION_ID = NVL(cp_recom_id, RCM.RECOMMENDATION_ID)