APPS.WIP_UNRELEASE dependencies on WIP_DISCRETE_JOBS

Line 16: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

12: po_req_exist VARCHAR2(20);
13:
14: cursor check_discrete_charges is
15: SELECT DISTINCT 'X'
16: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
17: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
18: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
19: AND DJ.WIP_ENTITY_ID = x_wip_id
20: AND DJ.ORGANIZATION_ID = x_org_id

Line 245: UPDATE WIP_DISCRETE_JOBS

241: x_wip_id =>P_wip_entity_id,
242: x_ent_type =>WIP_CONSTANTS.DISCRETE);
243:
244:
245: UPDATE WIP_DISCRETE_JOBS
246: SET STATUS_TYPE = WIP_CONSTANTS.UNRELEASED,
247: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
248: LAST_UPDATE_DATE = SYSDATE,
249: LAST_UPDATED_BY = X_user_id,