APPS.OKL_PERIOD_SWEEP_PVT dependencies on OKL_TRX_CONTRACTS_ALL

Line 43: FROM okl_trx_contracts_all tcn,

39: tcn.trx_number,
40: tcn.date_transaction_occurred,
41: tcl.line_number,
42: tcl.amount line_amount
43: FROM okl_trx_contracts_all tcn,
44: okl_txl_cntrct_lns_all tcl,
45: okl_strm_type_tl sty,
46: okl_trx_types_v try,
47: okc_k_headers_all_b khr

Line 227: OKL_TRX_CONTRACTS_ALL TCN,

223: SELECT TCN.ID,
224: TCN.ACCRUAL_REVERSAL_DATE,
225: TRY.TRX_TYPE_CLASS
226: FROM OKL_TXL_CNTRCT_LNS_ALL TXL ,
227: OKL_TRX_CONTRACTS_ALL TCN,
228: OKL_TRX_TYPES_B TRY
229: WHERE TXL.ID = p_txl_id AND
230: TXL.TCN_ID = TCN.ID AND
231: TCN.TRY_ID = TRY.ID