1149: FROM WIP_DJ_CLOSE_TEMP wdct, wip_discrete_jobs wdj
1150: WHERE wdct.ORGANIZATION_ID = p_organization_id
1151: AND wdct.GROUP_ID = p_group_id
1152: and wdj.wip_entity_id = wdct.WIP_ENTITY_ID
1153: and wdj.status_type = WIP_CONSTANTS.PEND_CLOSE);
1154:
1155:
1156: EXCEPTION
1157: WHEN others THEN
1200: and wdj.wip_entity_id = ewod.wip_entity_id
1201: and wdj.organization_id = ewod.organization_id
1202: and wdj.wip_entity_id = we.wip_entity_id
1203: and wdj.organization_id = we.organization_id
1204: and we.entity_type = WIP_CONSTANTS.EAM;
1205:
1206:
1207: BEGIN
1208: