APPS.OKL_LEASE_APP_PVT dependencies on AR_CMGT_CF_RECOMMENDS

Line 183: l_cr_recom AR_CMGT_CF_RECOMMENDS.CREDIT_RECOMMENDATION%TYPE;

179: RETURN VARCHAR2
180: IS
181: --Local variables
182: l_cr_decision VARCHAR2(50);
183: l_cr_recom AR_CMGT_CF_RECOMMENDS.CREDIT_RECOMMENDATION%TYPE;
184: l_cr_status AR_CMGT_CF_RECOMMENDS.STATUS%TYPE;
185:
186: --Cursor to check for Approve or Reject recommendation for a
187: --given Lease Application

Line 184: l_cr_status AR_CMGT_CF_RECOMMENDS.STATUS%TYPE;

180: IS
181: --Local variables
182: l_cr_decision VARCHAR2(50);
183: l_cr_recom AR_CMGT_CF_RECOMMENDS.CREDIT_RECOMMENDATION%TYPE;
184: l_cr_status AR_CMGT_CF_RECOMMENDS.STATUS%TYPE;
185:
186: --Cursor to check for Approve or Reject recommendation for a
187: --given Lease Application
188: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS

Line 191: FROM AR_CMGT_CF_RECOMMENDS RCM

187: --given Lease Application
188: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
189: SELECT RCM.CREDIT_RECOMMENDATION
190: , RCM.STATUS
191: FROM AR_CMGT_CF_RECOMMENDS RCM
192: , AR_CMGT_CREDIT_REQUESTS CCR
193: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
194: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
195: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 289: FROM AR_CMGT_CF_RECOMMENDS RCM

285: --Cursor to check for Approve or Reject recommendation for a
286: --given Lease Application
287: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
288: SELECT COUNT(*)
289: FROM AR_CMGT_CF_RECOMMENDS RCM
290: , AR_CMGT_CREDIT_REQUESTS CCR
291: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
292: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
293: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 384: FROM AR_CMGT_CF_RECOMMENDS RCM

380: --given Lease Application
381: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
382: SELECT RCM.CREDIT_RECOMMENDATION
383: , RCM.APPEALED_FLAG
384: FROM AR_CMGT_CF_RECOMMENDS RCM
385: , AR_CMGT_CREDIT_REQUESTS CCR
386: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
387: AND RCM.CREDIT_RECOMMENDATION IN ('REJECT', 'APPROVE')
388: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 449: FROM AR_CMGT_CF_RECOMMENDS RCM

445: --Cursor to check for Approve or Reject recommendation for a
446: --given Lease Application
447: CURSOR credit_recom_csr(cp_lap_id NUMBER) IS
448: SELECT COUNT(*)
449: FROM AR_CMGT_CF_RECOMMENDS RCM
450: , AR_CMGT_CREDIT_REQUESTS CCR
451: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
452: AND RCM.CREDIT_RECOMMENDATION IN ('APPROVE', 'EXPIRATION_DATE')
453: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 461: FROM AR_CMGT_CF_RECOMMENDS RCM

457: --given Lease Application
458: CURSOR appeal_flag_csr(p_lap_id NUMBER)
459: IS
460: SELECT RCM.APPEALED_FLAG
461: FROM AR_CMGT_CF_RECOMMENDS RCM
462: , AR_CMGT_CREDIT_REQUESTS CCR
463: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
464: AND RCM.CREDIT_RECOMMENDATION = 'EXPIRATION_DATE'
465: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 6475: FROM AR_CMGT_CF_RECOMMENDS RCM

6471:
6472: --Cursor to check whether a given recommendation is added to given Lease App
6473: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2, p_appeal VARCHAR2) IS
6474: SELECT COUNT(*)
6475: FROM AR_CMGT_CF_RECOMMENDS RCM
6476: , AR_CMGT_CREDIT_REQUESTS CCR
6477: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
6478: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6479: AND RCM.CREDIT_RECOMMENDATION = NVL(p_recomm, RCM.CREDIT_RECOMMENDATION)

Line 6489: , AR_CMGT_CF_RECOMMENDS RCM

6485: IS
6486: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
6487: FROM AR_CMGT_CASE_FOLDERS CCF
6488: , AR_CMGT_CREDIT_REQUESTS CCR
6489: , AR_CMGT_CF_RECOMMENDS RCM
6490: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
6491: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
6492: AND CCF.STATUS = 'CLOSED'
6493: AND RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID

Line 8020: FROM AR_CMGT_CF_RECOMMENDS RCM

8016: --Bug 4753078 Cursor to check for Approve or Reject recommendation for a
8017: --given Lease Application
8018: CURSOR credit_recom_csr(cp_lap_id NUMBER, p_recom VARCHAR2) IS
8019: SELECT COUNT(*)
8020: FROM AR_CMGT_CF_RECOMMENDS RCM
8021: , AR_CMGT_CREDIT_REQUESTS CCR
8022: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8023: AND RCM.CREDIT_RECOMMENDATION = p_recom
8024: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 8043: FROM AR_CMGT_CF_RECOMMENDS CCRM

8039: --Lease App
8040: CURSOR ocm_counter_offer_csr(cp_lap_id NUMBER, cp_co_id NUMBER)
8041: IS
8042: SELECT 'X'
8043: FROM AR_CMGT_CF_RECOMMENDS CCRM
8044: , AR_CMGT_CREDIT_REQUESTS CCR
8045: WHERE CCRM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
8046: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
8047: AND CCRM.CREDIT_RECOMMENDATION = 'COUNTER_OFFER'

Line 9628: FROM AR_CMGT_CF_RECOMMENDS RCM

9624:
9625: --Cursor to check whether a given recommendation is added to given Lease App
9626: CURSOR credit_recom_csr(p_lap_id NUMBER, p_recomm VARCHAR2) IS
9627: SELECT COUNT(*)
9628: FROM AR_CMGT_CF_RECOMMENDS RCM
9629: , AR_CMGT_CREDIT_REQUESTS CCR
9630: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
9631: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9632: AND RCM.CREDIT_RECOMMENDATION = p_recomm

Line 9641: , AR_CMGT_CF_RECOMMENDS RCM

9637: IS
9638: SELECT RCM.RECOMMENDATION_VALUE1 + TRUNC(LAST_UPDATED) APPEAL_EXP_DATE
9639: FROM AR_CMGT_CASE_FOLDERS CCF
9640: , AR_CMGT_CREDIT_REQUESTS CCR
9641: , AR_CMGT_CF_RECOMMENDS RCM
9642: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
9643: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'
9644: AND CCF.STATUS = 'CLOSED'
9645: AND RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID

Line 11301: FROM AR_CMGT_CF_RECOMMENDS RCM

11297: , RCM.CREDIT_REQUEST_ID
11298: , RCM.CREDIT_RECOMMENDATION
11299: , RCM.RECOMMENDATION_NAME
11300: , RCM.APPEALED_FLAG
11301: FROM AR_CMGT_CF_RECOMMENDS RCM
11302: , AR_CMGT_CREDIT_REQUESTS CCR
11303: WHERE RCM.CREDIT_REQUEST_ID = CCR.CREDIT_REQUEST_ID
11304: AND RCM.CREDIT_RECOMMENDATION = NVL(cp_cr_recom, RCM.CREDIT_RECOMMENDATION)
11305: AND RCM.RECOMMENDATION_ID = NVL(cp_recom_id, RCM.RECOMMENDATION_ID)