APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_ENTITIES

Line 525: from wip_discrete_jobs wdj, wip_entities we

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

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

711: -- Get Wip_Enttity_Name and Primary Item Id
712:
713: select wip_entity_name,entity_type,primary_item_id
714: into l_wip_entity_name, l_entity_type , l_primary_item_id
715: from wip_entities where organization_id = l_organization_id and wip_entity_id = l_wip_entity_id;
716:
717: l_stmt_num := 110;
718:
719: -- Get Project Id and Task Id