APPS.PAY_IE_PAY_ADVICE_REPORT SQL Statements

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

Line: 12

       select ADDRESS_LINE_1 into l_address_line_1
       from  hr_locations_all
           where location_code = p_location_code and
                 nvl(BUSINESS_GROUP_ID,p_business_group_id) =
                                        p_business_group_id;

Line: 34

       select ADDRESS_LINE_2 into l_address_line_2
       from  hr_locations_all
           where location_code = p_location_code and
                 nvl(BUSINESS_GROUP_ID,p_business_group_id) =
                                        p_business_group_id;

Line: 56

       select ADDRESS_LINE_3 into l_address_line_3
       from  hr_locations_all
           where location_code = p_location_code and
                 nvl(BUSINESS_GROUP_ID,p_business_group_id) =
                                        p_business_group_id;

Line: 82

    select HR_COUNTY.meaning into l_REGION_1
       from  hr_locations_all,
           	 HR_LOOKUPS  HR_COUNTY
           where location_code = p_location_code and
                 nvl(BUSINESS_GROUP_ID,p_business_group_id) =
                                        p_business_group_id   AND
                 HR_COUNTY.LOOKUP_TYPE(+) ='IE_COUNTY' AND
                 HR_COUNTY.LOOKUP_CODE(+) = REGION_1 AND
                 p_effective_date between nvl(START_DATE_ACTIVE,p_effective_date)
                 and  nvl(END_DATE_ACTIVE,p_effective_date);

Line: 108

       select REGION_2 into l_region_2
       from  hr_locations_all
           where location_code = p_location_code and
                 nvl(BUSINESS_GROUP_ID,p_business_group_id) =
                                        p_business_group_id;

Line: 130

       select TERRITORY_SHORT_NAME into l_country
       from  hr_locations_all,
            FND_TERRITORIES_VL fnd_ter
           where location_code = p_location_code and
                 nvl(BUSINESS_GROUP_ID,p_business_group_id) =
                                        p_business_group_id and
                 FND_TER.TERRITORY_CODE(+) = COUNTRY;