APPS.EAM_OP_COMP_VALIDATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 140

		SELECT shutdown_type into l_shutdown_type
		  FROM wip_discrete_jobs
                 WHERE wip_entity_id =    p_eam_op_comp_rec.wip_entity_id;

Line: 188

	    select count(won.prior_operation)
	    from wip_operation_networks won
	    where
		won.wip_entity_id  = p_eam_op_comp_rec.wip_entity_id and
		won.next_operation = p_eam_op_comp_rec.operation_seq_num and
		exists (
			select 1 from wip_operations
			where
			    wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
			    operation_seq_num = won.prior_operation and
			    nvl(operation_completed,'N') <> 'Y'
		);

Line: 202

	    select count(won.next_operation)
	    from wip_operation_networks won
	    where
		won.wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
		won.prior_operation = p_eam_op_comp_rec.operation_seq_num and
		exists (
			select 1 from wip_operations
			where
			    wip_entity_id = p_eam_op_comp_rec.wip_entity_id and
			    operation_seq_num = won.next_operation and
			    operation_completed = 'Y'
		);

Line: 217

	      select nvl(max(actual_end_date),sysdate-20000)
	      from eam_op_completion_txns eoct,wip_operation_networks won
	      where eoct.wip_entity_id = p_eam_op_comp_rec.wip_entity_id
	      and eoct.operation_seq_num=won.prior_operation
	      and won.wip_entity_id=eoct.wip_entity_id
	      and won.next_operation=p_eam_op_comp_rec.operation_seq_num
	      and transaction_type=1
	       and transaction_id = (select max(transaction_id)
				  from eam_op_completion_txns
				  where wip_entity_id = p_eam_op_comp_rec.wip_entity_id
					and operation_seq_num = eoct.operation_seq_num
					);

Line: 378

      SELECT NVL(MIN(period_start_date), sysdate+1)
        INTO l_open_acct_per_date
        FROM org_acct_periods
       WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
         AND open_flag = 'Y';

Line: 414

	  SELECT ml.lookup_code
            INTO l_reconciliation_code
            FROM mfg_lookups ml			-- Fix for Bug 3509465
           WHERE ml.lookup_type = 'WIP_EAM_RECONCILIATION_CODE'
             AND ml.lookup_code = p_eam_op_comp_rec.reconciliation_code;

Line: 447

	SELECT shutdown_type
	  INTO l_shutdown_type
	  FROM wip_operations
	 WHERE wip_entity_id    = p_eam_op_comp_rec.wip_entity_id
	  AND operation_seq_num = p_eam_op_comp_rec.operation_seq_num;

Line: 562

         SELECT status_type
           INTO l_job_status
           FROM wip_discrete_jobs
          WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;