APPS.WIP_CHANGE_STATUS dependencies on WIP_PERIOD_BALANCES

Line 87: INSERT INTO WIP_PERIOD_BALANCES

83: end if;
84:
85:
86: IF P_repetitive_schedule_id IS NULL THEN
87: INSERT INTO WIP_PERIOD_BALANCES
88: (ACCT_PERIOD_ID, WIP_ENTITY_ID,
89: LAST_UPDATE_DATE, LAST_UPDATED_BY,
90: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
91: ORGANIZATION_ID, CLASS_TYPE,

Line 123: FROM WIP_PERIOD_BALANCES WPB

119: P_organization_id))
120: AND OAP.PERIOD_CLOSE_DATE IS NULL
121: AND NOT EXISTS
122: (SELECT 'balance record already there'
123: FROM WIP_PERIOD_BALANCES WPB
124: WHERE WPB.WIP_ENTITY_ID = P_wip_entity_id
125: AND WPB.ACCT_PERIOD_ID = OAP.ACCT_PERIOD_ID
126: AND WPB.ORGANIZATION_ID = OAP.ORGANIZATION_ID);
127:

Line 134: INSERT INTO WIP_PERIOD_BALANCES

130: x_returnStatus => x_returnStatus);
131: end if;
132:
133: ELSE
134: INSERT INTO WIP_PERIOD_BALANCES
135: (ACCT_PERIOD_ID, WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID,
136: LAST_UPDATE_DATE, LAST_UPDATED_BY,
137: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
138: ORGANIZATION_ID, CLASS_TYPE,