APPS.IGS_OR_VAL_OU SQL Statements

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

Line: 132

  	SELECT	org_unit_cd


  	FROM	IGS_OR_UNIT


  	WHERE	org_unit_cd = p_org_unit_cd


  	AND	start_dt <> p_start_dt


  	AND	end_dt IS NULL;

Line: 206

  	SELECT	closed_ind


  	FROM	IGS_OR_STATUS


  	WHERE	org_status = p_org_status


  	AND	closed_ind = 'Y';

Line: 286

  	SELECT	s_org_status


  	FROM	IGS_OR_STATUS


  	WHERE	org_status = p_org_status;

Line: 307

  	SELECT	parent_org_unit_cd,


  		parent_start_dt,


  		s_org_status


  	FROM	IGS_OR_UNIT_REL,


  		IGS_OR_UNIT,


  		IGS_OR_STATUS


  	WHERE	child_org_unit_cd = cp_org_unit_cd


  	AND	child_start_dt = cp_start_dt


  	AND	logical_delete_dt IS NULL


  	AND	org_unit_cd = parent_org_unit_cd


  	AND	start_dt = parent_start_dt


  	AND	IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status;

Line: 349

  	SELECT	child_org_unit_cd,


  		child_start_dt


  	FROM	IGS_OR_UNIT_REL,


  		IGS_OR_UNIT,


  		IGS_OR_STATUS


  	WHERE	parent_org_unit_cd = p_org_unit_cd


  	AND	parent_start_dt = p_start_dt


  	AND	logical_delete_dt IS NULL


  	AND	org_unit_cd = child_org_unit_cd


  	AND	start_dt = child_start_dt


  	AND	IGS_OR_UNIT.org_status = IGS_OR_STATUS.org_status


  	AND	s_org_status = 'ACTIVE';

Line: 600

  	SELECT	enabled_flag


  	FROM	IGS_LOOKUP_VALUES

        WHERE   lookup_type = 'OR_ORG_TYPE'

  	AND	lookup_code = p_org_type

  	AND	enabled_flag = 'N';

Line: 671

  	SELECT	enabled_flag


  	FROM	IGS_LOOKUP_VALUES

        WHERE   lookup_type = 'OR_MEMBER_TYPE'


  	AND 	lookup_code = p_member_type


  	AND	enabled_flag = 'N';

Line: 743

  	SELECT	s_institution_status


  	FROM	IGS_OR_INSTITUTION,


  		IGS_OR_INST_STAT


  	WHERE	IGS_OR_INSTITUTION.institution_cd = p_institution_cd


  	AND	IGS_OR_INST_STAT.institution_status = IGS_OR_INSTITUTION.institution_status


  	AND	s_institution_status <> 'ACTIVE';

Line: 826

  	SELECT	start_dt,


  		end_dt


  	FROM	IGS_OR_UNIT


  	WHERE	org_unit_cd = p_org_unit_cd


  	AND	start_dt <> p_start_dt;

Line: 972

  	SELECT	s_org_status


  	FROM	IGS_OR_STATUS


  	WHERE	org_status = p_org_status;