APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_ENTITIES

Line 521: from wip_discrete_jobs wdj, wip_entities we

517: --start of fix for 3949853
518:
519: select wdj.status_type, we.entity_type
520: into l_status_type, l_we_entity_type
521: from wip_discrete_jobs wdj, wip_entities we
522: where wdj.wip_entity_id = we.wip_entity_id
523: and wdj.wip_entity_id = l_wip_entity_id;
524:
525: if ( ((l_status_type = 3) or (l_status_type = 4)) and l_we_entity_type = 6) then

Line 747: from wip_entities where organization_id = l_organization_id and wip_entity_id = l_wip_entity_id;

743: -- Get Wip_Enttity_Name and Primary Item Id
744:
745: select wip_entity_name,entity_type,primary_item_id
746: into l_wip_entity_name, l_entity_type , l_primary_item_id
747: from wip_entities where organization_id = l_organization_id and wip_entity_id = l_wip_entity_id;
748:
749: l_stmt_num := 110;
750:
751: -- Get Project Id and Task Id