APPS.AMS_SCR_LEAD_PVT SQL Statements

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

Line: 68

   select as_import_interface_s.nextval
   from dual;

Line: 73

   select subject_id person_party_id, object_id org_party_id
   from hz_relationships
   where party_id = l_rel_party_id
   and
   relationship_type = 'CONTACT'
   and
   directional_flag = 'F'
   and
   relationship_code = 'CONTACT_OF';

Line: 99

	      --insert into ams_script_tmp
	      --values('B2C partyId='||p_party_type, sysdate);

Line: 110

		--   insert into ams_script_tmp
		--   values('B2B partyId='||p_party_type, sysdate);

Line: 124

   INSERT INTO
   AS_IMPORT_INTERFACE
   (
     IMPORT_INTERFACE_ID,
     CREATED_BY,
     CREATION_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATE_LOGIN,
     LOAD_TYPE,
     LOAD_DATE,
     LOAD_STATUS,
     STATUS_CODE,
     PROMOTION_CODE,
     BATCH_ID,
     SOURCE_SYSTEM,
     CUSTOMER_NAME,
     CUSTOMER_TYPE,
     FIRST_NAME,
     LAST_NAME,
     EMAIL_ADDRESS,
     PHONE_NUMBER,
     PHONE_TYPE,
     ADDRESS1,
     ADDRESS2,
     ADDRESS3,
     ADDRESS4,
     CITY,
     STATE,
     POSTAL_CODE,
     COUNTRY,
     BUDGET_AMOUNT,
     CURRENCY_CODE,
     BUDGET_STATUS_CODE,
     DECISION_TIMEFRAME_CODE,
     CONTACT_ROLE_CODE,
     category_id_1,   --bug3287870; modified interest_type_id_1 to category_type_id