APPS.OKL_XLA_EVENTS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 2158: AND source_table = 'OKL_TXL_CNTRCT_LNS'

2154: OPEN get_event_csr FOR
2155: SELECT accounting_event_id, gl_date
2156: FROM okl_trns_acc_dstrs
2157: WHERE original_dist_id IS NULL
2158: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2159: AND source_id = (SELECT id
2160: FROM okl_txl_cntrct_lns
2161: WHERE tcn_id = p_tcn_id
2162: AND rownum = 1)

Line 2160: FROM okl_txl_cntrct_lns

2156: FROM okl_trns_acc_dstrs
2157: WHERE original_dist_id IS NULL
2158: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2159: AND source_id = (SELECT id
2160: FROM okl_txl_cntrct_lns
2161: WHERE tcn_id = p_tcn_id
2162: AND rownum = 1)
2163: AND accounting_event_id is not null
2164: AND rownum = 1;

Line 2170: AND source_table = 'OKL_TXL_CNTRCT_LNS'

2166: OPEN get_event_csr FOR
2167: SELECT accounting_event_id, gl_date
2168: FROM okl_trns_acc_dstrs
2169: WHERE original_dist_id IS NOT NULL
2170: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2171: AND source_id = (SELECT id
2172: FROM okl_txl_cntrct_lns
2173: WHERE tcn_id = p_tcn_id
2174: AND rownum = 1)

Line 2172: FROM okl_txl_cntrct_lns

2168: FROM okl_trns_acc_dstrs
2169: WHERE original_dist_id IS NOT NULL
2170: AND source_table = 'OKL_TXL_CNTRCT_LNS'
2171: AND source_id = (SELECT id
2172: FROM okl_txl_cntrct_lns
2173: WHERE tcn_id = p_tcn_id
2174: AND rownum = 1)
2175: AND accounting_event_id IS NOT NULL
2176: AND rownum = 1;

Line 2181: WHERE source_table = 'OKL_TXL_CNTRCT_LNS'

2177: ELSE
2178: OPEN get_event_csr FOR
2179: SELECT accounting_event_id, gl_date
2180: FROM okl_trns_acc_dstrs
2181: WHERE source_table = 'OKL_TXL_CNTRCT_LNS'
2182: AND source_id = (SELECT id
2183: FROM okl_txl_cntrct_lns
2184: WHERE tcn_id = p_tcn_id
2185: AND rownum = 1)

Line 2183: FROM okl_txl_cntrct_lns

2179: SELECT accounting_event_id, gl_date
2180: FROM okl_trns_acc_dstrs
2181: WHERE source_table = 'OKL_TXL_CNTRCT_LNS'
2182: AND source_id = (SELECT id
2183: FROM okl_txl_cntrct_lns
2184: WHERE tcn_id = p_tcn_id
2185: AND rownum = 1)
2186: AND accounting_event_id IS NOT NULL
2187: AND rownum = 1;