APPS.PER_NEW_HIRE_PKG SQL Statements

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

Line: 56

REM                                                insert a line feed.
REM ========================================================================
REM
*/
--
-- Global variables and Constants.
--
g_character_set		varchar2(80);

Line: 1976

  select address_line_1, address_line_2, address_line_3,
         town_or_city, region_1, region_2, postal_code ,style
  from hr_locations
  where  location_id = p_location_id;

Line: 2106

  select address_line_1, address_line_2, address_line_3,
         town_or_city, region_1, region_2, postal_code
         ,country,style
  from hr_locations
  where  location_id = p_location_id;

Line: 2248

  select address_line1, address_line2, address_line3,
	 town_or_city, region_1, region_2, postal_code
         ,style
  from 	 per_addresses
  where  person_id = p_person_id
  and 	 primary_flag = 'Y'
  and    nvl(date_to, sysdate) >= sysdate;

Line: 2378

  select address_line1, address_line2, address_line3,
	 town_or_city, region_1, region_2
         , postal_code ,country ,style
  from 	 per_addresses
  where  person_id = p_person_id
  and 	 primary_flag = 'Y'
  and    nvl(date_to, sysdate) >= sysdate;

Line: 2499

 Select  ppf.first_name || ' ' || ppf.last_name,
                 job.name,
                 ppf.work_telephone
         From
                 --per_people_f          ppf, --view bug 4912696
                  per_all_people_f       ppf,  --table
                 --per_assignments_f     paf, --view bug 4912696
                 per_all_assignments_f   paf, --table
                 per_jobs                job
         Where
                 ppf.person_id                   = p_person_id
         And     ppf.business_group_id + 0       = p_business_group_id
         And     p_report_date   between paf.effective_start_date
                                 and     paf.effective_end_date
         And     ppf.person_id                   = paf.person_id
         And     paf.assignment_type             = 'E'
         And     paf.primary_flag                = 'Y'
         And     p_report_date   between paf.effective_start_date
                                 and     paf.effective_end_date
         -- BUG2919553
         And     ppf.effective_start_date =
                      (select max(ppf1.effective_start_date)
                       from per_all_people_f ppf1  --table bug 4912696
                       where ppf1.person_id = ppf.person_id
                       and   ppf1.effective_start_date <= p_report_date
                      )
         -- End of BUG2919553
         And     paf.job_id      = job.job_id(+);