APPS.IEX_UWQ_SEL_PKG SQL Statements

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

Line: 283

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

Line: 303

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

Line: 309

      SELECT campaign_id
	    FROM ams_p_campaigns_v
	    WHERE source_code = x_campaignCode
	    AND status_code ='ACTIVE';

Line: 341

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

Line: 361

	SELECT p.party_id, p.object_id
	FROM   JTF_PARTIES_V p, jtf_party_relationships_v rel
	WHERE  p.party_number = x_contactNum ;

Line: 376

      SELECT party_id
	FROM jtf_parties_v
	WHERE party_number = x_custnum;

Line: 391

      SELECT party_id
	FROM hz_cust_accounts
	WHERE account_number = x_account_num;

Line: 406

	SELECT party_id, party_type
	FROM   JTF_CONTACT_POINTS_V
	WHERE  phone_number = x_phonenumber ;

Line: 411

	SELECT party_id, party_type
	FROM   JTF_CONTACT_POINTS_V
	WHERE  AREA_CODE = x_AreaCode and PHONE_NUMBER = x_phonenumber;

Line: 416

	   SELECT object_id, subject_id from
		 HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid
		 AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
		 AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
		 AND DIRECTIONAL_FLAG = 'F';

Line: 490

   insert into ast_uwq_params  values ('handleOTSBound Called ');

Line: 573

   insert into ast_uwq_params  values ('handleOTSBound exit : Action Name: '
	    || p_action_Name || ' Action Type : '
	    || to_char(p_action_Type) || ' Action Param: '
	    || p_action_Param );

Line: 711

       SELECT customer_id
       INTO l_nm_PARTY_ID
       from jtf_tasks_b
       WHERE task_id=l_Task_ID;