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 1487: CURSOR c_fee_srv_asset_dtls(lp_fee_srv_id OKL_FEES_B.ID%TYPE) IS

1483: l_adj_rec BINARY_INTEGER;
1484: lx_return_status VARCHAR2(1);
1485: --Cursor declaration
1486: --Get the assets details linked with fee lines
1487: CURSOR c_fee_srv_asset_dtls(lp_fee_srv_id OKL_FEES_B.ID%TYPE) IS
1488: SELECT olrb.SOURCE_LINE_ID,
1489: olrb.amount
1490: FROM okl_line_relationships_b olrb
1491: WHERE olrb.RELATED_LINE_ID = lp_fee_srv_id

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

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

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

2074: -- sechawla 05-nov-09 End Bug 9044309
2075:
2076:
2077: --Get service expense details
2078: CURSOR c_get_service_expense_dtls(p_service_id okl_fees_b.ID%TYPE) IS
2079: SELECT ocf.STY_ID payment_type_id,
2080: ocf.DUE_ARREARS_YN Arrears_YN,
2081: cfl.FQY_CODE Frequency_Code,
2082: cfl.START_DATE,

Line 2392: FROM okl_fees_b ofb

2388: ROLLOVER_QUOTE_ID,
2389: INITIAL_DIRECT_COST,
2390: FEE_AMOUNT AMOUNT,
2391: FEE_PURPOSE_CODE
2392: FROM okl_fees_b ofb
2393: WHERE ofb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2394: AND ofb.PARENT_OBJECT_ID = p_qte_id;
2395:
2396: --Get fee payment details

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

2393: WHERE ofb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2394: AND ofb.PARENT_OBJECT_ID = p_qte_id;
2395:
2396: --Get fee payment details
2397: CURSOR c_get_fee_payment_dtls(p_fee_id okl_fees_b.ID%TYPE) IS
2398: SELECT ocf.STY_ID payment_type_id,
2399: ocf.DUE_ARREARS_YN Arrears_YN,
2400: cfl.FQY_CODE Frequency_Code,
2401: cfl.START_DATE,

Line 2411: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'

2407: OKL_CASH_FLOWS ocf,
2408: OKL_CASH_FLOW_LEVELS cfl
2409: WHERE cfl.caf_id = ocf.ID
2410: AND ocf.CFO_ID = cfo.ID
2411: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'
2412: AND ocf.CFT_CODE ='PAYMENT_SCHEDULE'
2413: AND cfo.SOURCE_ID = p_fee_id
2414: -- sechawla 5-nov-09 : Bug 9044309
2415: ORDER BY

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

2417: -- sechawla 5-nov-09 End Bug 9044309
2418:
2419:
2420: --Get fee expense details
2421: CURSOR c_get_fee_expense_dtls(p_fee_id okl_fees_b.ID%TYPE) IS
2422: SELECT ocf.STY_ID payment_type_id,
2423: ocf.DUE_ARREARS_YN Arrears_YN,
2424: cfl.FQY_CODE Frequency_Code,
2425: cfl.START_DATE,

Line 2435: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'

2431: OKL_CASH_FLOWS ocf,
2432: OKL_CASH_FLOW_LEVELS cfl
2433: WHERE cfl.caf_id = ocf.ID
2434: AND ocf.CFO_ID = cfo.ID
2435: AND cfo.SOURCE_TABLE = 'OKL_FEES_B'
2436: AND ocf.CFT_CODE ='OUTFLOW_SCHEDULE'
2437: AND cfo.SOURCE_ID = p_fee_id;
2438:
2439: -- Bug 12938353: Added by RGOOTY