APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_SERVICES_B

Line 2049: FROM okl_services_b osb

2045: SELECT ID,
2046: INV_ITEM_ID,
2047: EFFECTIVE_FROM,
2048: SUPPLIER_ID
2049: FROM okl_services_b osb
2050: WHERE osb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2051: AND osb.PARENT_OBJECT_ID = p_qte_id;
2052:
2053: --Get service payment details

Line 2068: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'

2064: OKL_CASH_FLOWS ocf,
2065: OKL_CASH_FLOW_LEVELS cfl
2066: WHERE cfl.caf_id = ocf.ID
2067: AND ocf.CFO_ID = cfo.ID
2068: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'
2069: AND cfo.SOURCE_ID = p_service_id
2070: AND ocf.cft_code = 'PAYMENT_SCHEDULE'
2071: -- sechawla 05-nov-09 Bug 9044309
2072: ORDER BY

Line 2092: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'

2088: OKL_CASH_FLOWS ocf,
2089: OKL_CASH_FLOW_LEVELS cfl
2090: WHERE cfl.caf_id = ocf.ID
2091: AND ocf.CFO_ID = cfo.ID
2092: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'
2093: AND cfo.SOURCE_ID = p_service_id
2094: AND ocf.cft_code = 'OUTFLOW_SCHEDULE';
2095: BEGIN
2096: x_return_status := OKL_API.G_RET_STS_SUCCESS;