APPS.WIP_MASSLOAD_PUB dependencies on WIP_PERIOD_BALANCES

Line 291: INSERT INTO WIP_PERIOD_BALANCES

287: end loop;
288:
289: -- Bug Fix 12383088. Create Period Balance for Periods created during WML run when Job was uncommitted and unhandled in INVCPOPEN.
290: for wdj_rec in cur_wdj loop
291: INSERT INTO WIP_PERIOD_BALANCES
292: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
293: LAST_UPDATE_DATE, LAST_UPDATED_BY,
294: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
295: ORGANIZATION_ID, CLASS_TYPE,

Line 324: FROM WIP_PERIOD_BALANCES WPB

320: AND OAP.ORGANIZATION_ID = wdj_rec.organization_id
321: AND OAP.SCHEDULE_CLOSE_DATE >= TRUNC(wdj_rec.date_released)
322: AND OAP.PERIOD_CLOSE_DATE IS NULL
323: AND NOT EXISTS (SELECT 'balance record already there'
324: FROM WIP_PERIOD_BALANCES WPB
325: WHERE WPB.WIP_ENTITY_ID = wdj_rec.wip_entity_id
326: AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID
327: AND WPB.ORGANIZATION_ID = OAP.ORGANIZATION_ID);
328: end loop;