APPS.IGS_EN_VAL_API SQL Statements

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

Line: 30

  p_inserting IN BOOLEAN ,
  p_updating IN BOOLEAN ,
  p_deleting IN BOOLEAN ,
  p_message_name OUT NOCOPY VARCHAR2)
  RETURN BOOLEAN AS
  	v_index			BINARY_INTEGER;

Line: 41

  		SELECT 	'x'
  		FROM	IGS_PE_PERSON_ID_TYP		pit
  		WHERE	pit.person_id_type 	= cp_person_id_type AND
  			pit.s_person_id_type 	= cst_pay_adv_no AND
			pit.closed_ind = 'N' ;

Line: 51

  			SELECT	*
  			INTO	r_alternate_person_id
  			FROM	IGS_PE_ALT_PERS_ID
  			WHERE	rowid = gt_rowid_table(v_index);

Line: 96

  		SELECT 	'x'
  		FROM	IGS_PE_ALT_PERS_ID	api,
  			IGS_PE_PERSON_ID_TYP		pit
  		WHERE	api.api_person_id 	= p_pay_advice_number 	AND
  			api.pe_person_id 	 <>  p_person_id		AND
  			api.person_id_type 	= pit.person_id_type 	AND
  			pit.s_person_id_type 	= cst_pay_adv_no;

Line: 160

    SELECT COUNT(1)
    FROM   IGS_PE_ALT_PERS_ID A,
           IGS_PE_ALT_PERS_ID B
    WHERE  A.pe_person_id   =  cp_person_id
    AND    A.pe_person_id   =  B.pe_person_id
    AND    A.person_id_type =  B.person_id_type
    AND    A.ROWID  <> B.ROWID
    AND    A.START_DT < NVL(B.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD'))
    AND    NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <>  A.START_DT
    AND    NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) >  B.START_DT
    AND    (
    NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <= NVL(B.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD'))
    OR
    A.END_DT <= B.END_DT
    );

Line: 182

   SELECT  count('x')
   FROM    igs_pe_alt_pers_id
   WHERE   pe_person_id = cp_person_id
   AND     end_dt IS NULL
   GROUP BY pe_person_id,PERSON_ID_TYPE
   HAVING count('x') >1;

Line: 235

    SELECT COUNT(1)
    FROM   IGS_PE_ALT_PERS_ID A,
           IGS_PE_ALT_PERS_ID B
    WHERE  A.pe_person_id   =  cp_person_id
    AND    A.pe_person_id   =  B.pe_person_id
    AND    A.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
    AND    B.person_id_type IN (SELECT person_id_type FROM IGS_PE_PERSON_ID_TYP WHERE s_person_id_type = 'SSN')
    AND    A.ROWID  <> B.ROWID
    AND    A.START_DT < NVL(B.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD'))
    AND    NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <>  A.START_DT
    AND    NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) >  B.START_DT
    AND    (
    NVL(A.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD')) <= NVL(B.END_DT,TO_DATE('4712/12/31','YYYY/MM/DD'))
    OR
    A.END_DT <= B.END_DT
    );

Line: 256

   SELECT  count('x')
   FROM    igs_pe_alt_pers_id
   WHERE   pe_person_id = cp_person_id
   AND    PERSON_ID_TYPE IN ( select person_id_type from igs_pe_person_id_typ
                             where S_PERSON_ID_TYPE='SSN' )
   AND     end_dt IS NULL
   GROUP BY pe_person_id,PERSON_ID_TYPE;