APPS.IGS_GE_MNT_SDTT SQL Statements

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

Line: 14

  	--- Delete a record from the s_disable_table_trigger
  	--- database table.
	CURSOR CUR_DISB_TAB_TRG IS
	SELECT ROWID , IGS_GE_S_DSB_TAB_TRG.*
  	FROM	IGS_GE_S_DSB_TAB_TRG
  	WHERE	table_name = p_table_name	AND
  		session_id = (
  			SELECT	userenv('SESSIONID')
  			FROM	dual );

Line: 25

		IGS_GE_S_DSB_TAB_TRG_PKG.DELETE_ROW(X_ROWID => DISB_TAB_TRG_REC.ROWID );

Line: 46

		SELECT 'X'
		FROM igs_pe_per_type_map
		WHERE system_type = cp_staff_var;

Line: 51

	SELECT 'X'
	FROM per_all_people_f
	WHERE party_id = cp_person_id;

Line: 56

		SELECT NVL(HZ.KNOWN_AS, SUBSTR (HZ.PERSON_FIRST_NAME, 1, DECODE(INSTR(HZ.PERSON_FIRST_NAME, ' '),
			0, LENGTH(HZ.PERSON_FIRST_NAME), (INSTR(HZ.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || HZ.PERSON_LAST_NAME
			PREFERRED_NAME
		FROM  IGS_PE_PERSON_TYPES PT,IGS_PE_TYP_INSTANCES_ALL PTI,HZ_PARTIES HZ
		WHERE HZ.PARTY_ID = PTI.PERSON_ID
		     AND HZ.PARTY_ID = cp_person_id
		     AND PTI.PERSON_TYPE_CODE = PT.PERSON_TYPE_CODE
		     AND PT.SYSTEM_TYPE = cp_staff_var
		     AND TRUNC(SYSDATE) BETWEEN TRUNC(PTI.START_DATE) AND TRUNC(NVL(PTI.END_DATE,SYSDATE))
		     AND HZ.STATUS = 'A';

Line: 69

		SELECT  NVL(HZ.KNOWN_AS, SUBSTR (HZ.PERSON_FIRST_NAME, 1, DECODE(INSTR(HZ.PERSON_FIRST_NAME, ' '),
			0, LENGTH(HZ.PERSON_FIRST_NAME), (INSTR(HZ.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || HZ.PERSON_LAST_NAME
			PREFERRED_NAME
	       FROM PER_PERSON_TYPE_USAGES_F USG,PER_ALL_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ
	       WHERE HZ.PARTY_ID = peo.party_id
		     AND USG.PERSON_ID = PEO.PERSON_ID
		     AND HZ.PARTY_ID = cp_person_id
		     AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID
		     AND MAP.SYSTEM_TYPE = cp_staff_var AND
		     TRUNC(SYSDATE) BETWEEN TRUNC(PEO.EFFECTIVE_START_DATE) AND TRUNC(PEO.EFFECTIVE_END_DATE)
		     AND TRUNC(SYSDATE) BETWEEN TRUNC(USG.EFFECTIVE_START_DATE) AND TRUNC(USG.EFFECTIVE_END_DATE)
		     AND HZ.STATUS = 'A';