APPS.IGS_OR_VAL_OUR SQL Statements

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

Line: 16

	SELECT  org_unit_cd
	FROM    IGS_OR_UNIT
	WHERE   org_unit_cd = cp_org_unit_cd
	AND     start_dt = cp_start_dt;

Line: 24

	SELECT  s_org_status
	FROM    IGS_OR_UNIT,
		IGS_OR_STATUS
	WHERE   org_unit_cd = cp_org_unit_cd
	AND     start_dt = cp_start_dt
	AND     IGS_OR_STATUS.org_status = IGS_OR_UNIT.org_status
	AND     s_org_status = 'INACTIVE';

Line: 42

		SELECT  parent_org_unit_cd,
			parent_start_dt
		FROM    IGS_OR_UNIT_REL
		WHERE   child_org_unit_cd = p_org_unit_cd
		AND     child_start_dt = p_start_dt
		AND     logical_delete_dt IS NULL;