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_LOSS_PROV_PVT dependencies on OKL_TRX_TYPES_TL

Line 1130: FROM OKL_TRX_TYPES_TL

1126:
1127: -- cursor to get transaction type id
1128: CURSOR trx_types_csr IS
1129: SELECT id
1130: FROM OKL_TRX_TYPES_TL
1131: WHERE NAME = l_try_name
1132: AND LANGUAGE = 'US';
1133:
1134: -- cursor to get stream type name

Line 2298: l_try_name CONSTANT OKL_TRX_TYPES_TL.NAME%TYPE := 'Specific Loss Provision';

2294: -- constants
2295: l_api_name CONSTANT VARCHAR2(40) := 'SPECIFIC_LOSS_PROVISION';
2296: l_api_version CONSTANT NUMBER := 1.0;
2297: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PSP';
2298: l_try_name CONSTANT OKL_TRX_TYPES_TL.NAME%TYPE := 'Specific Loss Provision';
2299: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PSP';
2300: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
2301: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
2302: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';

Line 2353: FROM OKL_TRX_TYPES_TL

2349:
2350: -- cursor to get transaction type id
2351: CURSOR trx_types_csr IS
2352: SELECT id
2353: FROM OKL_TRX_TYPES_TL
2354: WHERE NAME = l_try_name
2355: AND LANGUAGE = 'US';
2356:
2357: -- cursor to get scs_code