APPS.OKL_UWQ_SEL_PKG SQL Statements

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

Line: 218

      SELECT registrant_party_Id,registrant_contact_Id,event_offer_Id
	FROM  ams_event_registrations_v
	WHERE confirmation_code = x_eventConfCode;

Line: 233

      SELECT campaign_id
      FROM ams_campaigns_all_b
      WHERE translate(inbound_phone_no,'0123456789()/\-. ','0123456789')=x_inbound_phone
	    AND status_code ='ACTIVE';

Line: 238

     SELECT SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE, SOC.SOURCE_CODE_FOR_ID
     FROM aMS_SOURCE_CODES SOC, AMS_ACT_CONTACT_POINTS AACP
     WHERE SOC.SOURCE_CODE_FOR_ID = AACP.ACT_CONTACT_USED_BY_ID AND
      SOC.ARC_SOURCE_CODE_FOR = AACP.ARC_CONTACT_USED_BY AND
      SOC.ACTIVE_FLAG = 'Y' AND AACP.CONTACT_POINT_TYPE = 'PHONE'
      AND AACP.CONTACT_POINT_VALUE = x_inbound_phone;

Line: 245

      SELECT source_code_id, source_code_for_id
	    FROM ams_source_codes
	    WHERE source_code = x_campaignCode
	    AND active_flag = 'Y';

Line: 297

      SELECT quote_header_id,party_id,cust_account_id,l_contactid
	    FROM ASO_QUOTE_HEADERS_ALL
	    WHERE quote_number = x_collateralReqNum;

Line: 311

	SELECT p.party_id, rel.object_id
	FROM   hz_parties p, hz_relationships_v rel
	WHERE  p.party_number = x_contactNum
        AND   p.party_id = rel.party_id;

Line: 322

      SELECT party_id
	FROM hz_parties
	WHERE party_number = x_custnum;

Line: 332

      SELECT party_id
	FROM hz_cust_accounts
	WHERE account_number = x_account_num;

Line: 343

	SELECT party_id, party_type
	FROM   JTF_CONTACT_POINTS_V
	WHERE  phone_number = x_phonenumber AND status = 'A' ;

Line: 347

	SELECT party_id, party_type
	FROM   JTF_CONTACT_POINTS_V
	 WHERE  (AREA_CODE||PHONE_NUMBER) = x_phonenumber AND status = 'A';

Line: 351

	   SELECT object_id, subject_id FROM
		 HZ_PARTY_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid;