DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 2061: OKL_CASH_FLOW_LEVELS cfl

2057: cfl.NUMBER_OF_PERIODS,
2058: cfl.AMOUNT
2059: FROM OKL_CASH_FLOW_OBJECTS cfo,
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

Line 2079: OKL_CASH_FLOW_LEVELS cfl

2075: cfl.NUMBER_OF_PERIODS,
2076: cfl.AMOUNT
2077: FROM OKL_CASH_FLOW_OBJECTS cfo,
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

Line 2398: OKL_CASH_FLOW_LEVELS cfl

2394: cfl.NUMBER_OF_PERIODS,
2395: cfl.AMOUNT
2396: FROM OKL_CASH_FLOW_OBJECTS cfo,
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'

Line 2417: OKL_CASH_FLOW_LEVELS cfl

2413: cfl.NUMBER_OF_PERIODS,
2414: cfl.AMOUNT
2415: FROM OKL_CASH_FLOW_OBJECTS cfo,
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'

Line 3504: OKL_CASH_FLOW_LEVELS cfl

3500: cfl.NUMBER_OF_PERIODS,
3501: cfl.AMOUNT
3502: FROM OKL_CASH_FLOW_OBJECTS cfo,
3503: OKL_CASH_FLOWS ocf,
3504: OKL_CASH_FLOW_LEVELS cfl
3505: WHERE cfl.caf_id = ocf.ID
3506: AND ocf.CFO_ID = cfo.ID
3507: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3508: AND cfo.OTY_CODE = 'QUOTED_ASSET'

Line 3523: OKL_CASH_FLOW_LEVELS cfl

3519: cfl.NUMBER_OF_PERIODS,
3520: cfl.AMOUNT
3521: FROM OKL_CASH_FLOW_OBJECTS cfo,
3522: OKL_CASH_FLOWS ocf,
3523: OKL_CASH_FLOW_LEVELS cfl
3524: WHERE cfl.caf_id = ocf.ID
3525: AND ocf.CFO_ID = cfo.ID
3526: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3527: AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'

Line 3542: OKL_CASH_FLOW_LEVELS cfl

3538: cfl.NUMBER_OF_PERIODS,
3539: cfl.AMOUNT
3540: FROM OKL_CASH_FLOW_OBJECTS cfo,
3541: OKL_CASH_FLOWS ocf,
3542: OKL_CASH_FLOW_LEVELS cfl
3543: WHERE cfl.caf_id = ocf.ID
3544: AND ocf.CFO_ID = cfo.ID
3545: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3546: AND cfo.OTY_CODE = 'QUOTED_ASSET_PROPERTY_TAX'

Line 3561: OKL_CASH_FLOW_LEVELS cfl

3557: cfl.NUMBER_OF_PERIODS,
3558: cfl.AMOUNT
3559: FROM OKL_CASH_FLOW_OBJECTS cfo,
3560: OKL_CASH_FLOWS ocf,
3561: OKL_CASH_FLOW_LEVELS cfl
3562: WHERE cfl.caf_id = ocf.ID
3563: AND ocf.CFO_ID = cfo.ID
3564: AND cfo.SOURCE_TABLE = 'OKL_LEASE_QUOTES_B'
3565: AND cfo.SOURCE_ID = p_qte_id;