APPS.CLN_RN_UTILS SQL Statements

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

Line: 340

     SELECT org.name
     , null
     , loc.telephone_number_1
     , loc.telephone_number_2
     , loc.ece_tp_location_code
     INTO x_name
     , x_email
     , x_telephone
     , x_fax
     , x_ece_location_code
     FROM hr_locations_all loc,  hr_all_organization_units_vl org
     WHERE org.location_id      = loc.location_id
     AND org.organization_id    = p_org_id;

Line: 407

     SELECT party_type, party_id, party_site_id
     INTO l_party_type, l_party_id, l_party_site_id
     FROM ECX_TP_HEADERS
     WHERE tp_header_id = p_tp_header_id;

Line: 417

        SELECT pv.vendor_name,  pvsa.area_code || ' ' || pvsa.phone, pvsa.fax_area_code || ' ' || pvsa.fax,
               pvsa.ece_tp_location_code, pvsa.email_address
        INTO x_name, x_telephone, x_fax, x_ece_location_code, x_email
        FROM  po_vendors pv, po_vendor_sites_all pvsa
        WHERE pv.vendor_id = pvsa.vendor_id
          AND pv.vendor_id = l_party_id
          AND pvsa.vendor_site_id = l_party_site_id;

Line: 425

        SELECT BANK_BRANCH_NAME,hcp.RAW_PHONE_NUMBER,hcp.EDI_ECE_TP_LOCATION_CODE
	INTO x_name, x_telephone, x_ece_location_code
        FROM CE_BANK_BRANCHES_V bb, HZ_PARTIES hp, HZ_contact_points hcp
        WHERE bb.BRANCH_PARTY_ID = l_party_id
              AND  bb.BRANCH_PARTY_ID = hp.party_id
	      AND  hp.PRIMARY_PHONE_CONTACT_PT_ID = hcp.CONTACT_POINT_ID;

Line: 432

        SELECT location_code, telephone_number_1, ece_tp_location_code
        INTO x_name, x_telephone, x_ece_location_code
        FROM HR_LOCATIONS
        WHERE location_id = l_party_id;

Line: 437

        SELECT hz.party_name
        INTO x_name
        FROM hz_parties hz
        WHERE hz.party_id = l_party_id;

Line: 442

           Select phone_number, email_address
           Into   x_telephone, x_email
           From   hz_contact_points
           Where  owner_table_name = 'HZ_PARTIES'
             and  owner_table_id = l_party_id
             and rownum < 1;

Line: 824

         CURSOR c_validations(p_document_type in varchar2) IS SELECT XML_ELEMENT, MINIMUM_LENGTH, MAXIMUM_LENGTH, DATA_TYPE, oracle_format_mask
               FROM CLN_RN_VALIDATIONS
               WHERE document_type = p_document_type;

Line: 1043

   select count(*)
   into l_count
   from fnd_user
   where user_name = p_user_name;

Line: 1052

   select user_id
   into x_user_id
   from fnd_user
   where user_name = p_user_name;

Line: 1277

      SELECT payload into l_xmlDoc FROM ecx_doclogs  WHERE internal_control_number = p_internal_control_num;

Line: 1573

    select substr (p_instring,1,p_numofchar) into x_outstring from dual;