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 343: FROM AR_CMGT_CASE_FOLDERS CCF

339: --given Lease Application
340: CURSOR case_folder_csr(p_lap_id NUMBER)
341: IS
342: SELECT LAP.CR_EXP_DAYS + TRUNC(LAST_UPDATED) APPR_EXP_DATE
343: FROM AR_CMGT_CASE_FOLDERS CCF
344: , AR_CMGT_CREDIT_REQUESTS CCR
345: , OKL_LEASE_APPLICATIONS_B LAP
346: WHERE CCR.CREDIT_REQUEST_ID = CCF.CREDIT_REQUEST_ID
347: AND CCR.SOURCE_COLUMN3 = 'LEASEAPP'

Line 6618: FROM AR_CMGT_CASE_FOLDERS CCF

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

Line 9770: FROM AR_CMGT_CASE_FOLDERS CCF

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