DBA Data[Home] [Help]

APPS.CST_PERIODSUMMARY_PVT dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 136: FROM wsm_split_merge_transactions

132: END IF;
133:
134: SELECT COUNT(*)
135: INTO l_count
136: FROM wsm_split_merge_transactions
137: WHERE organization_id = p_org_id
138: AND costed <> wip_constants.completed
139: AND transaction_date < l_sched_close_date;
140:

Line 142: l_unprocessed_table := 'WSM_SPLIT_MERGE_TRANSACTIONS';

138: AND costed <> wip_constants.completed
139: AND transaction_date < l_sched_close_date;
140:
141: IF l_count <> 0 THEN
142: l_unprocessed_table := 'WSM_SPLIT_MERGE_TRANSACTIONS';
143: RAISE l_unprocessed_txn;
144: END IF;
145:
146: SELECT COUNT(*)