DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 2065: OKL_CASH_FLOW_LEVELS cfl

2061: cfl.NUMBER_OF_PERIODS,
2062: cfl.AMOUNT
2063: FROM OKL_CASH_FLOW_OBJECTS cfo,
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

Line 2089: OKL_CASH_FLOW_LEVELS cfl

2085: cfl.NUMBER_OF_PERIODS,
2086: cfl.AMOUNT
2087: FROM OKL_CASH_FLOW_OBJECTS cfo,
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

Line 2408: OKL_CASH_FLOW_LEVELS cfl

2404: cfl.NUMBER_OF_PERIODS,
2405: cfl.AMOUNT
2406: FROM OKL_CASH_FLOW_OBJECTS cfo,
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'

Line 2432: OKL_CASH_FLOW_LEVELS cfl

2428: cfl.NUMBER_OF_PERIODS,
2429: cfl.AMOUNT
2430: FROM OKL_CASH_FLOW_OBJECTS cfo,
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'

Line 3550: OKL_CASH_FLOW_LEVELS cfl

3546: cfl.NUMBER_OF_PERIODS,
3547: cfl.AMOUNT
3548: FROM OKL_CASH_FLOW_OBJECTS cfo,
3549: OKL_CASH_FLOWS ocf,
3550: OKL_CASH_FLOW_LEVELS cfl
3551: WHERE cfl.caf_id = ocf.ID
3552: AND ocf.CFO_ID = cfo.ID
3553: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3554: AND cfo.OTY_CODE = 'QUOTED_ASSET'

Line 3574: OKL_CASH_FLOW_LEVELS cfl

3570: cfl.NUMBER_OF_PERIODS,
3571: cfl.AMOUNT
3572: FROM OKL_CASH_FLOW_OBJECTS cfo,
3573: OKL_CASH_FLOWS ocf,
3574: OKL_CASH_FLOW_LEVELS cfl
3575: WHERE cfl.caf_id = ocf.ID
3576: AND ocf.CFO_ID = cfo.ID
3577: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3578: AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'

Line 3593: OKL_CASH_FLOW_LEVELS cfl

3589: cfl.NUMBER_OF_PERIODS,
3590: cfl.AMOUNT
3591: FROM OKL_CASH_FLOW_OBJECTS cfo,
3592: OKL_CASH_FLOWS ocf,
3593: OKL_CASH_FLOW_LEVELS cfl
3594: WHERE cfl.caf_id = ocf.ID
3595: AND ocf.CFO_ID = cfo.ID
3596: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3597: AND cfo.OTY_CODE = 'QUOTED_ASSET_PROPERTY_TAX'

Line 3612: OKL_CASH_FLOW_LEVELS cfl

3608: cfl.NUMBER_OF_PERIODS,
3609: cfl.AMOUNT
3610: FROM OKL_CASH_FLOW_OBJECTS cfo,
3611: OKL_CASH_FLOWS ocf,
3612: OKL_CASH_FLOW_LEVELS cfl
3613: WHERE cfl.caf_id = ocf.ID
3614: AND ocf.CFO_ID = cfo.ID
3615: AND cfo.SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
3616: AND cfo.SOURCE_ID = p_qte_id;