APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_SERVICES_B

Line 2045: FROM okl_services_b osb

2041: SELECT ID,
2042: INV_ITEM_ID,
2043: EFFECTIVE_FROM,
2044: SUPPLIER_ID
2045: FROM okl_services_b osb
2046: WHERE osb.PARENT_OBJECT_CODE = 'LEASEQUOTE'
2047: AND osb.PARENT_OBJECT_ID = p_qte_id;
2048:
2049: --Get service payment details

Line 2064: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'

2060: OKL_CASH_FLOWS ocf,
2061: OKL_CASH_FLOW_LEVELS cfl
2062: WHERE cfl.caf_id = ocf.ID
2063: AND ocf.CFO_ID = cfo.ID
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

Line 2082: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'

2078: OKL_CASH_FLOWS ocf,
2079: OKL_CASH_FLOW_LEVELS cfl
2080: WHERE cfl.caf_id = ocf.ID
2081: AND ocf.CFO_ID = cfo.ID
2082: AND cfo.SOURCE_TABLE = 'OKL_SERVICES_B'
2083: AND cfo.SOURCE_ID = p_service_id
2084: AND ocf.cft_code = 'OUTFLOW_SCHEDULE';
2085: BEGIN
2086: x_return_status := OKL_API.G_RET_STS_SUCCESS;