DBA Data[Home] [Help]

APPS.OKL_XLA_EVENTS_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 2173: FROM okl_trns_acc_dstrs

2169:
2170: IF p_action_type = 'CREATE' THEN
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

Line 2185: FROM okl_trns_acc_dstrs

2181: AND rownum = 1;
2182: ELSIF p_action_type = 'REVERSE' THEN
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

Line 2197: FROM okl_trns_acc_dstrs

2193: AND rownum = 1;
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