eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LEASE_APP_PVT dependencies on AR_CMGT_CASE_FOLDERS

Line 301: FROM AR_CMGT_CASE_FOLDERS CCF

297: --given Lease Application
298: CURSOR case_folder_csr(p_lap_id NUMBER)
299: IS
300: SELECT LAP.CR_EXP_DAYS + TRUNC(LAST_UPDATED) APPR_EXP_DATE
301: FROM AR_CMGT_CASE_FOLDERS CCF
302: , AR_CMGT_CREDIT_REQUESTS CCR
303: , OKL_LEASE_APPLICATIONS_B LAP
304: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
305: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 6487: FROM AR_CMGT_CASE_FOLDERS CCF

6483: --Cursor to obtain appeal period expiration date for a given Lease App
6484: CURSOR appeal_exp_date_csr(p_lap_id NUMBER)
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'

Line 9639: FROM AR_CMGT_CASE_FOLDERS CCF

9635: --Cursor to obtain appeal period expiration date for a given Lease App
9636: CURSOR appeal_exp_date_csr(p_lap_id NUMBER)
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'