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 291: UPDATE WIP_DISCRETE_JOBS

287: x_wip_id =>P_wip_entity_id,
288: x_ent_type =>WIP_CONSTANTS.DISCRETE);
289:
290:
291: UPDATE WIP_DISCRETE_JOBS
292: SET STATUS_TYPE = WIP_CONSTANTS.UNRELEASED,
293: DATE_RELEASED = NVL(DATE_RELEASED, SYSDATE),
294: LAST_UPDATE_DATE = SYSDATE,
295: LAST_UPDATED_BY = X_user_id,