DBA Data[Home] [Help]

APPS.CST_PERIODSUMMARY_PVT dependencies on WSM_SPLIT_MERGE_TXN_INTERFACE

Line 148: FROM wsm_split_merge_txn_interface

144: END IF;
145:
146: SELECT COUNT(*)
147: INTO l_count
148: FROM wsm_split_merge_txn_interface
149: WHERE organization_id = p_org_id
150: AND process_status <> wip_constants.completed
151: AND transaction_date < l_sched_close_date;
152:

Line 154: l_unprocessed_table := 'WSM_SPLIT_MERGE_TXN_INTERFACE';

150: AND process_status <> wip_constants.completed
151: AND transaction_date < l_sched_close_date;
152:
153: IF l_count <> 0 THEN
154: l_unprocessed_table := 'WSM_SPLIT_MERGE_TXN_INTERFACE';
155: RAISE l_unprocessed_txn;
156: END IF;
157:
158: -- check if there are untransferred distributions in MTA/WTA