DBA Data[Home] [Help]

APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_CASH_FLOWS

Line 9591: okl_cash_flows caf,

9587: qco.base_source_id line_id,
9588: caf.sts_code,
9589: cfo.oty_code
9590: FROM okl_trx_qte_cf_objects qco,
9591: okl_cash_flows caf,
9592: okl_cash_flow_objects cfo
9593: WHERE cfo.ID = qco.cfo_id
9594: AND cfo.ID =
9595: caf.cfo_id(+)

Line 9642: FROM okl_cash_flows

9638: sty_id,
9639: dnz_khr_id,
9640: number_of_advance_periods,
9641: due_arrears_yn
9642: FROM okl_cash_flows
9643: WHERE cfo_id = cp_cfo_id
9644: AND sts_code = 'PROPOSED'
9645: AND cft_code = 'PAYMENT_SCHEDULE';
9646:

Line 9703: FROM okl_cash_flows caf,

9699: cfl.stub_amount,
9700: NVL (caf.due_arrears_yn, 'N') due_arrears_yn,
9701: -- SECHAWLA 20-SEP-04 3816891 : Added
9702: cfl.fqy_code -- SECHAWLA 20-SEP-04 3816891 : Added
9703: FROM okl_cash_flows caf,
9704: okl_cash_flow_levels cfl
9705: WHERE cfo_id = cp_cfo_id
9706: AND caf.sty_id = cp_sty_id
9707: AND caf.ID = cfl.caf_id