APPS.WIP_CHANGE_STATUS dependencies on WIP_PERIOD_BALANCES

Line 61: INSERT INTO WIP_PERIOD_BALANCES

57: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
58:
59: BEGIN
60: IF P_repetitive_schedule_id IS NULL THEN
61: INSERT INTO WIP_PERIOD_BALANCES
62: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
63: LAST_UPDATE_DATE, LAST_UPDATED_BY,
64: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
65: ORGANIZATION_ID, CLASS_TYPE,

Line 97: FROM WIP_PERIOD_BALANCES WPB

93: P_organization_id))
94: AND OAP.PERIOD_CLOSE_DATE IS NULL
95: AND NOT EXISTS
96: (SELECT 'balance record already there'
97: FROM WIP_PERIOD_BALANCES WPB
98: WHERE WPB.WIP_ENTITY_ID = P_wip_entity_id
99: AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID
100: AND WPB.ORGANIZATION_ID = OAP.ORGANIZATION_ID);
101: ELSE

Line 102: INSERT INTO WIP_PERIOD_BALANCES

98: WHERE WPB.WIP_ENTITY_ID = P_wip_entity_id
99: AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID
100: AND WPB.ORGANIZATION_ID = OAP.ORGANIZATION_ID);
101: ELSE
102: INSERT INTO WIP_PERIOD_BALANCES
103: (ACCT_PERIOD_ID, WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID,
104: LAST_UPDATE_DATE, LAST_UPDATED_BY,
105: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
106: ORGANIZATION_ID, CLASS_TYPE,