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_QUOTE_TO_CONTRACT_PVT dependencies on OKL_FEES_B

Line 1482: CURSOR c_fee_srv_asset_dtls(lp_fee_srv_id OKL_FEES_B.ID%TYPE) IS

1478: l_adj_rec BINARY_INTEGER;
1479: lx_return_status VARCHAR2(1);
1480: --Cursor declaration
1481: --Get the assets details linked with fee lines
1482: CURSOR c_fee_srv_asset_dtls(lp_fee_srv_id OKL_FEES_B.ID%TYPE) IS
1483: SELECT olrb.SOURCE_LINE_ID,
1484: olrb.amount
1485: FROM okl_line_relationships_b olrb
1486:

Line 2050: CURSOR c_get_service_payment_dtls(p_service_id okl_fees_b.ID%TYPE) IS

2046: WHERE osb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2047: AND osb.PARENT_OBJECT_ID = p_qte_id;
2048:
2049: --Get service payment details
2050: CURSOR c_get_service_payment_dtls(p_service_id okl_fees_b.ID%TYPE) IS
2051: SELECT ocf.STY_ID payment_type_id,
2052: ocf.DUE_ARREARS_YN Arrears_YN,
2053: cfl.FQY_CODE Frequency_Code,
2054: cfl.START_DATE,

Line 2068: CURSOR c_get_service_expense_dtls(p_service_id okl_fees_b.ID%TYPE) IS

2064: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'
2065: AND cfo.SOURCE_ID = p_service_id
2066: AND ocf.cft_code = 'PAYMENT_SCHEDULE';
2067: --Get service expense details
2068: CURSOR c_get_service_expense_dtls(p_service_id okl_fees_b.ID%TYPE) IS
2069: SELECT ocf.STY_ID payment_type_id,
2070: ocf.DUE_ARREARS_YN Arrears_YN,
2071: cfl.FQY_CODE Frequency_Code,
2072: cfl.START_DATE,

Line 2382: FROM okl_fees_b ofb

2378: ROLLOVER_QUOTE_ID,
2379: INITIAL_DIRECT_COST,
2380: FEE_AMOUNT AMOUNT,
2381: FEE_PURPOSE_CODE
2382: FROM okl_fees_b ofb
2383: WHERE ofb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2384: AND ofb.PARENT_OBJECT_ID = p_qte_id;
2385:
2386: --Get fee payment details

Line 2387: CURSOR c_get_fee_payment_dtls(p_fee_id okl_fees_b.ID%TYPE) IS

2383: WHERE ofb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2384: AND ofb.PARENT_OBJECT_ID = p_qte_id;
2385:
2386: --Get fee payment details
2387: CURSOR c_get_fee_payment_dtls(p_fee_id okl_fees_b.ID%TYPE) IS
2388: SELECT ocf.STY_ID payment_type_id,
2389: ocf.DUE_ARREARS_YN Arrears_YN,
2390: cfl.FQY_CODE Frequency_Code,
2391: cfl.START_DATE,

Line 2401: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'

2397: OKL_CASH_FLOWS ocf,
2398: OKL_CASH_FLOW_LEVELS cfl
2399: WHERE cfl.caf_id = ocf.ID
2400: AND ocf.CFO_ID = cfo.ID
2401: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'
2402: AND ocf.CFT_CODE ='PAYMENT_SCHEDULE'
2403: AND cfo.SOURCE_ID = p_fee_id;
2404:
2405: --Get fee expense details

Line 2406: CURSOR c_get_fee_expense_dtls(p_fee_id okl_fees_b.ID%TYPE) IS

2402: AND ocf.CFT_CODE ='PAYMENT_SCHEDULE'
2403: AND cfo.SOURCE_ID = p_fee_id;
2404:
2405: --Get fee expense details
2406: CURSOR c_get_fee_expense_dtls(p_fee_id okl_fees_b.ID%TYPE) IS
2407: SELECT ocf.STY_ID payment_type_id,
2408: ocf.DUE_ARREARS_YN Arrears_YN,
2409: cfl.FQY_CODE Frequency_Code,
2410: cfl.START_DATE,

Line 2420: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'

2416: OKL_CASH_FLOWS ocf,
2417: OKL_CASH_FLOW_LEVELS cfl
2418: WHERE cfl.caf_id = ocf.ID
2419: AND ocf.CFO_ID = cfo.ID
2420: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'
2421: AND ocf.CFT_CODE ='OUTFLOW_SCHEDULE'
2422: AND cfo.SOURCE_ID = p_fee_id;
2423: BEGIN
2424: x_return_status := OKL_API.G_RET_STS_SUCCESS;