APPS.PON_ADD_UTIL_PKG SQL Statements

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

Line: 18

  SELECT
    hl.location_code
  , hl.address_line_1
  , hl.address_line_2
  , hl.town_or_city
  , hl.region_2
  , hl.region_3
  , hl.postal_code
  , hl.postal_code
  , hl.country
  , hl.region_1
  , hl.bill_to_site_flag
  , hl.ship_to_site_flag
  , hl.receiving_site_flag

  FROM hr_locations hl

  WHERE hl.location_id = p_location_id;

Line: 72

  SELECT
    hps.party_site_name
  , hl.ADDRESS1
  , hl.ADDRESS2
  , hl.CITY
  , hl.STATE
  , hl.PROVINCE
  , hl.POSTAL_PLUS4_CODE
  , hl.POSTAL_CODE
  , hl.COUNTRY
  , hl.county
  , hl.overseas_address_flag
  , DECODE (hpsu_bill_to.site_use_type, l_bill_to,'Y','N')
  , DECODE (hpsu_ship_to.site_use_type, l_ship_to,'Y','N')
  , DECODE (hpsu_mail_to.site_use_type, l_mail_to,'Y','N')

  FROM hz_locations hl
  , hz_party_sites hps
  , hz_party_site_uses hpsu_ship_to
  , hz_party_site_uses hpsu_bill_to
  , hz_party_site_uses hpsu_mail_to

  WHERE hl.location_id = p_location_id
  AND   hps.location_id = hl.location_id
  AND   hpsu_ship_to.party_site_id(+) = hps.party_site_id
  AND   hpsu_ship_to.site_use_type(+) = l_ship_to
  AND   hpsu_bill_to.party_site_id(+) = hps.party_site_id
  AND   hpsu_bill_to.site_use_type(+) = l_bill_to
  AND   hpsu_mail_to.party_site_id(+) = hps.party_site_id
  AND   hpsu_mail_to.site_use_type(+) = l_mail_to

  ORDER by hps.party_site_name;

Line: 126

  SELECT location_code
  INTO   x_address_name
  FROM   hr_locations_all_tl
  WHERE  location_id = p_location_id
  AND    language = p_language;