APPS.HZ_FORMAT_PHONE_V2PUB SQL Statements

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

Line: 191

      SELECT phone_country_code
      FROM   hz_phone_country_codes
      WHERE  territory_code = i_territory_code;

Line: 196

     SELECT PHONE_FORMAT_STYLE
     FROM  hz_phone_formats
     WHERE  territory_code = g_user_territory_code;

Line: 583

    SELECT territory_code
    FROM   hz_phone_country_codes
    WHERE  phone_country_code = p_country_code;

Line: 651

        select contact_point_type
        into   l_contact_point_type
        from   HZ_CONTACT_POINTS
        where  CONTACT_POINT_ID = p_contact_point_id;

Line: 694

        select phone_country_code , intl_prefix, trunk_prefix
        into l_user_country_code, l_phone_intl_prefix, l_phone_trunk_prefix
        from hz_phone_country_codes
        where territory_code = l_user_territory_code;

Line: 704

            select  phone_country_code,phone_area_code, phone_number
            into    l_phone_country_code ,l_phone_area_code, l_phone_number
            from    HZ_CONTACT_POINTS
            where   CONTACT_POINT_ID = p_contact_point_id
            and     CONTACT_POINT_TYPE = 'PHONE';

Line: 734

          select pc.territory_code
          into  l_phone_territory_code
          from hz_phone_country_codes pc
          where phone_country_code = l_phone_country_code
          AND exists (select phone_format_style
                     from hz_phone_formats pf
                     where pf.territory_code = pc.territory_code)
          AND rownum =1;

Line: 1399

       select count(mobile_prefix)
       into l_count_mobile_prefix
       from hz_mobile_prefixes
       where phone_country_code = p_phone_country_code;

Line: 1404

       select max(length(mobile_prefix))
       into l_length_mobile_prefix
       from hz_mobile_prefixes
       where phone_country_code = p_phone_country_code;

Line: 1417

           select mobile_prefix
           into l_mobile_prefix
           from hz_mobile_prefixes
           where mobile_prefix = l_mobile_prefix_check
           and phone_country_code = p_phone_country_code ;

Line: 1559

    SELECT null
    FROM   hz_party_preferences
    WHERE  party_id = p_party_id
    AND    ROWNUM = 1;

Line: 1647

    SELECT phone_country_code,
           trunk_prefix,
           intl_prefix
    FROM   hz_phone_country_codes
    WHERE  territory_code = p_territory_code;

Line: 1686

    SELECT pc.territory_code
    FROM   hz_phone_country_codes pc
    WHERE  phone_country_code = p_phone_country_code
    AND    EXISTS (
             SELECT null
             FROM   hz_phone_formats pf
             WHERE  pf.territory_code = pc.territory_code)
    AND    ROWNUM =1;

Line: 1742

       select intl_prefix
       into l_intl_prefix
       from hz_phone_country_codes
       where territory_code = p_territory_code;

Line: 1824

    select trunk_prefix
    into l_trunk_prefix
    from hz_phone_country_codes
    where territory_code = p_territory_code;

Line: 1910

           select phone_country_code
           into l_phone_country_code
           from hz_phone_country_codes
           where phone_country_code = l_country_code_check
           and rownum = 1;

Line: 1989

    SELECT area_code_length,
           phone_length
    into   l_area_code_length, l_phone_length
    from hz_phone_country_codes
    where phone_country_code = l_country_code_for_area_code
    and rownum = 1;

Line: 2014

     select count(area_code)
     into l_count_area_code
     from hz_phone_area_codes
     where phone_country_code = l_country_code_for_area_code;

Line: 2027

           select area_code
           into l_area_code
           from hz_phone_area_codes
           where area_code = l_area_code_check
           and phone_country_code = l_country_code_for_area_code;

Line: 2139

    SELECT pf.phone_format_style,
           pf.area_code_size,
           pcc.phone_country_code
    FROM   hz_phone_country_codes pcc,
           hz_phone_formats pf
    WHERE  pcc.territory_code = p_territory_code
    AND    pcc.territory_code = pf.territory_code;

Line: 2307

    SELECT phone_extension, hz_utility_v2pub.get_lookupmeaning('AR_LOOKUPS', 'PHONE_LINE_TYPE', phone_line_type)
    INTO x_phone_extension, x_phone_line_type
    FROM hz_contact_points
    WHERE contact_point_id = p_contact_point_id;