DBA Data[Home] [Help]

APPS.OKL_XLA_EVENTS_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 2156: FROM okl_trns_acc_dstrs

2152:
2153: IF p_action_type = 'CREATE' THEN
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

Line 2168: FROM okl_trns_acc_dstrs

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

Line 2180: FROM okl_trns_acc_dstrs

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