APPS.AST_UWQ_SEL_PKG SQL Statements

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

Line: 457

     SELECT registrant_party_Id,event_offer_Id
	FROM  ams_event_registrations
	WHERE confirmation_code = x_eventConfCode;

Line: 478

     SELECT SOC.SOURCE_CODE_ID, SOC.SOURCE_CODE
     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: 486

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

Line: 541

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

Line: 562

      SELECT quote_header_id,party_id
	    FROM ASO_QUOTE_HEADERS_ALL
	    WHERE quote_number = x_QuoteNum;

Line: 583

      SELECT o.header_id, a.party_id
	    FROM oe_order_headers_all o, hz_cust_accounts a
	    where o.order_number = x_OrderNum
	    and a.cust_account_id = o.sold_to_org_id;

Line: 604

      SELECT s.source_code, s.source_code_id, nvl(l.party_id,0)
	    FROM ams_list_entries l, ams_source_codes s
	    where l.pin_code = x_MPin
	    and l.source_code = s.source_code;

Line: 626

      SELECT to_number(p.object1_id1)
	    FROM okc_k_party_roles_b p , okc_k_headers_b k
	    where k.contract_number = x_ContractNum
	    and k.contract_number_modifier = nvl(x_ContractNumMod, k.contract_number_modifier)
	    and k.id = p.dnz_chr_id
	    and p.primary_yn = 'Y'
	    and p.jtot_object1_code = 'OKX_PARTY';

Line: 654

      SELECT owner_party_id
	    FROM csi_item_instances
	    where instance_number = x_ServiceKey
	    and owner_party_source_table = 'HZ_PARTIES';

Line: 674

      SELECT customer_id
	    FROM cs_incidents_all_b
	    where incident_number = x_SRNum;

Line: 693

	 SELECT rel.subject_id, rel.object_id
      FROM   hz_parties p, hz_relationships rel
      WHERE  p.party_number = x_contactNum
      AND    p.party_id = rel.party_id
      AND    rel.subject_type = 'PERSON'
      AND    rel.object_table_name = 'HZ_PARTIES'
      AND    rel.subject_table_name = 'HZ_PARTIES'
      AND    rel.object_type = 'ORGANIZATION';

Line: 703

     	SELECT party_id, party_type
		FROM hz_parties
		WHERE party_number = x_contactNum
		AND party_type = 'PARTY_RELATIONSHIP';

Line: 721

      SELECT party_id, party_type
	--FROM jtf_parties_v
	FROM hz_parties
	WHERE party_number = x_custnum;

Line: 745

   SELECT party_id,party_type
     FROM hz_parties
    WHERE party_id = x_custid;

Line: 765

     SELECT hzp.party_id, hza.cust_account_id, hzp.party_type
	FROM hz_cust_accounts hza, hz_parties hzp
     --SELECT hza.party_id, hza.cust_account_id
	--FROM hz_cust_accounts hza
	WHERE hza.account_number = x_account_num  and
	   hza.party_id = hzp.party_id;

Line: 773

	select a.cust_account_id
	from hz_cust_accounts a, hz_cust_account_roles ar
	where a.account_number = x_account_num
	and a.cust_account_id = ar.cust_account_id;

Line: 805

      SELECT customer_trx_id
	FROM ra_customer_trx
	WHERE trx_number  = to_char(InvoiceNum) ;

Line: 827

     SELECT cp.owner_table_id, p.party_type
     FROM   hz_contact_points cp, hz_parties p
     WHERE  cp.transposed_phone_number like x_phonenumber
     AND    cp.owner_table_name = 'HZ_PARTIES'
     AND    cp.status = 'A'
     AND    cp.owner_table_id = p.party_id;

Line: 836

	SELECT party_id, party_type
	FROM   JTF_CONTACT_POINTS_V
	WHERE  translate(phone_number,'0123456789()/\-. ','0123456789') = x_phonenumber and status = 'A' ;

Line: 841

	SELECT party_id, party_type
	FROM   JTF_CONTACT_POINTS_V
	 WHERE  translate(area_code||phone_number,'0123456789()/\-. ','0123456789')  = x_phonenumber and status = 'A';

Line: 846

	   SELECT object_id, subject_id from
		 HZ_PARTY_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid;

Line: 850

	   SELECT object_id, subject_id from
		 HZ_RELATIONSHIPS WHERE PARTY_ID = p_rel_partyid and
			object_type = 'ORGANIZATION' and subject_type = 'PERSON';

Line: 1330

select source_code_id from ams_source_codes where
--source_code_for_id = p_schedule_id and /* Commented for bug#4453994 */
--arc_source_code_for = 'CSCH' and /* Commented for bug#4453994 */
source_code = p_source_code;

Line: 1336

select source_code_id from ams_source_codes where
source_code = p_source_code;