APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 142: FROM wip_discrete_jobs

138: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE
139: THEN
140: --commented for bug 12843159
141: /*SELECT shutdown_type into l_shutdown_type
142: FROM wip_discrete_jobs
143: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
144: IF l_shutdown_type IS NOT NULL THEN*/
145:
146: --Added for bug 12843159

Line 390: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)

386: BEGIN
387: SELECT NVL(MIN(period_start_date), sysdate+1)
388: INTO l_open_acct_per_date
389: FROM org_acct_periods
390: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
391: AND open_flag = 'Y';
392:
393: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date
394: raise fnd_api.g_exc_unexpected_error;

Line 573: FROM wip_discrete_jobs

569: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN
570: begin
571: SELECT status_type
572: INTO l_job_status
573: FROM wip_discrete_jobs
574: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
575: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;
576:
577: IF (l_job_status = 4 ) THEN