APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_RESERVATIONS_V

Line 113: (SELECT 'X'FROM WIP_RESERVATIONS_V WRV

109: DJ.DATE_RELEASED <= p_to_release_date )
110: AND ( p_status IS NULL OR DJ.STATUS_TYPE = p_status)
111: -- AND ( DJ.DATE_RELEASED <= p_act_close_date) /* Bug 5007538 */
112: AND ( p_exclude_reserved_jobs <> '1' OR NOT EXISTS
113: (SELECT 'X'FROM WIP_RESERVATIONS_V WRV
114: WHERE WRV.WIP_ENTITY_ID = WE.WIP_ENTITY_ID ))
115: AND ( p_exclude_pending_txn_jobs <> '1' OR ( NOT EXISTS
116: (SELECT 'X' FROM WIP_MOVE_TXN_INTERFACE WMTI
117: WHERE WMTI.ORGANIZATION_ID = p_organization_id

Line 1190: FROM wip_reservations_v wrv,

1186: l_msg_count NUMBER;
1187:
1188: CURSOR C_del_reservation IS
1189: SELECT wrv.reservation_id
1190: FROM wip_reservations_v wrv,
1191: wip_dj_close_temp wdct
1192: WHERE wdct.organization_id = p_organization_id
1193: AND wdct.group_id = p_group_id
1194: AND wdct.wip_entity_id = wrv.wip_entity_id;