APPS.IGS_AD_GEN_009 SQL Statements

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

Line: 15

		SELECT	acos.adm_cndtnl_offer_status
		FROM	IGS_AD_CNDNL_OFRSTAT   acos
		WHERE	acos.s_adm_cndtnl_offer_status = p_s_adm_cndtnl_offer_status  AND
			acos.system_default_ind        = 'Y'			      AND
			acos.closed_ind		       = 'N';

Line: 49

		SELECT	ads.adm_doc_status
		FROM	IGS_AD_DOC_STAT ads
		WHERE	ads.s_adm_doc_status 	= p_s_adm_doc_status AND
			ads.system_default_ind  = 'Y' AND
			ads.closed_ind	        = 'N';

Line: 83

		SELECT	aeqs.adm_entry_qual_status
		FROM	IGS_AD_ENT_QF_STAT aeqs
		WHERE	aeqs.s_adm_entry_qual_status = p_s_adm_entry_qual_status AND
			aeqs.system_default_ind      = 'Y' AND
			aeqs.closed_ind	             = 'N';

Line: 117

		SELECT	afs.adm_fee_status
		FROM	IGS_AD_FEE_STAT afs
		WHERE	afs.s_adm_fee_status 	= p_s_adm_fee_status AND
			afs.system_default_ind  = 'Y' AND
			afs.closed_ind	        = 'N';

Line: 153

		SELECT	aods.adm_offer_dfrmnt_status
		FROM	IGS_AD_OFRDFRMT_STAT   aods
		WHERE	aods.s_adm_offer_dfrmnt_status = p_s_adm_offer_dfrmnt_status  AND
			aods.system_default_ind        = 'Y'		              AND
			aods.closed_ind		       = 'N';

Line: 189

		SELECT	aors.adm_offer_resp_status
		FROM	IGS_AD_OFR_RESP_STAT   aors
		WHERE	aors.s_adm_offer_resp_status = p_s_adm_offer_resp_status  AND
			aors.system_default_ind      = 'Y'			  AND
			aors.closed_ind		     = 'N';

Line: 225

		SELECT	aos.adm_outcome_status
		FROM	IGS_AD_OU_STAT   aos
		WHERE	aos.s_adm_outcome_status = p_s_adm_outcome_status  AND
			aos.system_default_ind   = 'Y'		           AND
			aos.closed_ind		 = 'N';

Line: 261

		SELECT	auos.adm_unit_outcome_status
		FROM	IGS_AD_UNIT_OU_STAT		auos
		WHERE	s_adm_outcome_status = p_s_adm_outcome_status	AND
			system_default_ind = 'Y'				AND
			closed_ind = 'N';