DBA Data[Home] [Help]

APPS.CST_PERIODSUMMARY_PVT dependencies on MTL_TRANSACTION_ACCOUNTS

Line 162: FROM mtl_transaction_accounts

158: -- check if there are untransferred distributions in MTA/WTA
159:
160: SELECT COUNT(*)
161: INTO l_count
162: FROM mtl_transaction_accounts
163: WHERE gl_batch_id = -1
164: AND organization_id = p_org_id
165: AND transaction_date < l_sched_close_date;
166:

Line 168: l_untransferred_table := 'MTL_TRANSACTION_ACCOUNTS';

164: AND organization_id = p_org_id
165: AND transaction_date < l_sched_close_date;
166:
167: IF l_count <> 0 THEN
168: l_untransferred_table := 'MTL_TRANSACTION_ACCOUNTS';
169: RAISE l_untransferred_dist;
170: END IF;
171:
172: SELECT COUNT(*)