APPS.HR_NL_CALC_TARGET_GROUP SQL Statements

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

Line: 16

      select  a.country_of_birth
      into    l_cnty_of_birth
      from    per_all_people_f a,
	      per_contact_relationships b
      where   a.person_id = b.contact_person_id and
	      b.person_id = p_person_id and
	      b.contact_type = p_contact_type and
	      p_session_date between a.effective_start_date and a.effective_end_date and
              p_session_date between nvl(b.date_start, p_session_date) and
                                     nvl(b.date_end, p_session_date) and
              ROWNUM = 1
      order by b.date_start desc;

Line: 36

        select a.country_of_birth
        into   l_cnty_of_birth
	from   per_all_people_f a,
	       per_contact_relationships b
	where  a.person_id = b.contact_person_id and
	       b.person_id = p_person_id and
	       b.contact_type = p_contact_type and
               p_session_date between nvl(b.date_start, p_session_date) and
                                      nvl(b.date_end, p_session_date) and
               ROWNUM = 1
        order by b.date_start desc, a.effective_start_date desc;

Line: 70

		select formula_id ,effective_start_date
			into l_formula_id,l_effective_start_date
		from ff_formulas_f_v
		where formula_name = 'NL_TARGET_GROUP'
			and p_session_date between effective_start_date and
                                                   effective_end_date
                   and verified = 'Y';

Line: 112

          select per_information11, per_information12
          into   l_local_birth_country_fth, l_local_birth_country_mth
          from   per_all_people_f
	  where  person_id = p_person_id
          and    p_session_date between effective_start_date
                 and effective_end_date;

Line: 142

          select country_of_birth,
                 business_group_id
          into   l_country_of_birth_emp,
                 l_business_group_id
	  from   per_all_people_f
	  where  person_id = p_person_id and
                 p_session_date between effective_start_date and effective_end_date;