DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on WIP_DISCRETE_JOBS

Line 486: select owning_department into l_owning_department_id from wip_discrete_jobs where wip_entity_id = p_wip_entity_id;

482:
483: x_reason_status := reason_status;
484:
485: if (p_wip_entity_id is not null) then
486: select owning_department into l_owning_department_id from wip_discrete_jobs where wip_entity_id = p_wip_entity_id;
487: end if;
488:
489:
490: -- Check for Charge Department entered through the JSP

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 753: select project_id,task_id into l_project_id, l_task_id from wip_discrete_jobs

749: l_stmt_num := 110;
750:
751: -- Get Project Id and Task Id
752:
753: select project_id,task_id into l_project_id, l_task_id from wip_discrete_jobs
754: where organization_id = l_organization_id and wip_entity_id = l_wip_entity_id;
755:
756: -- Get the chargeable flag .Changes for bug 9524124
757:

Line 935: from wip_discrete_jobs where wip_entity_id = l_wip_entity_id;

931: l_stmt_num := 200;
932:
933: select scheduled_start_date, scheduled_completion_date
934: into l_start_date, l_completion_date
935: from wip_discrete_jobs where wip_entity_id = l_wip_entity_id;
936:
937: l_stmt_num := 210;
938:
939: if (old_res_status = 0) then