APPS.OKL_XLA_EVENTS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 2175: AND source_table = 'OKL_TXL_CNTRCT_LNS'

2171: OPEN get_event_csr FOR
2172: SELECT accounting_event_id, gl_date
2173: FROM okl_trns_acc_dstrs
2174: WHERE original_dist_id IS NULL
2175: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2176: AND source_id = (SELECT id
2177: FROM okl_txl_cntrct_lns
2178: WHERE tcn_id = p_tcn_id
2179: AND rownum = 1)

Line 2177: FROM okl_txl_cntrct_lns

2173: FROM okl_trns_acc_dstrs
2174: WHERE original_dist_id IS NULL
2175: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2176: AND source_id = (SELECT id
2177: FROM okl_txl_cntrct_lns
2178: WHERE tcn_id = p_tcn_id
2179: AND rownum = 1)
2180: AND accounting_event_id is not null
2181: AND rownum = 1;

Line 2187: AND source_table = 'OKL_TXL_CNTRCT_LNS'

2183: OPEN get_event_csr FOR
2184: SELECT accounting_event_id, gl_date
2185: FROM okl_trns_acc_dstrs
2186: WHERE original_dist_id IS NOT NULL
2187: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2188: AND source_id = (SELECT id
2189: FROM okl_txl_cntrct_lns
2190: WHERE tcn_id = p_tcn_id
2191: AND rownum = 1)

Line 2189: FROM okl_txl_cntrct_lns

2185: FROM okl_trns_acc_dstrs
2186: WHERE original_dist_id IS NOT NULL
2187: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2188: AND source_id = (SELECT id
2189: FROM okl_txl_cntrct_lns
2190: WHERE tcn_id = p_tcn_id
2191: AND rownum = 1)
2192: AND accounting_event_id IS NOT NULL
2193: AND rownum = 1;

Line 2198: WHERE source_table = 'OKL_TXL_CNTRCT_LNS'

2194: ELSE
2195: OPEN get_event_csr FOR
2196: SELECT accounting_event_id, gl_date
2197: FROM okl_trns_acc_dstrs
2198: WHERE source_table = 'OKL_TXL_CNTRCT_LNS'
2199: AND source_id = (SELECT id
2200: FROM okl_txl_cntrct_lns
2201: WHERE tcn_id = p_tcn_id
2202: AND rownum = 1)

Line 2200: FROM okl_txl_cntrct_lns

2196: SELECT accounting_event_id, gl_date
2197: FROM okl_trns_acc_dstrs
2198: WHERE source_table = 'OKL_TXL_CNTRCT_LNS'
2199: AND source_id = (SELECT id
2200: FROM okl_txl_cntrct_lns
2201: WHERE tcn_id = p_tcn_id
2202: AND rownum = 1)
2203: AND accounting_event_id IS NOT NULL
2204: AND rownum = 1;