APPS.PAY_FR_MAP_CALC SQL Statements

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

Line: 138

    SELECT count(*)
     FROM  per_contact_relationships_v2 pcr
     WHERE pcr.person_id = p_person_id
        AND   dependent_flag = 'Y'
        AND  p_effective_date
          BETWEEN
              NVL(pcr.date_start, p_effective_date)
          AND NVL(pcr.date_end,p_effective_date)
        AND EXISTS
               ( SELECT pst.INFORMATION3 from per_shared_types pst
                  WHERE pcr.contact_type = pst.system_type_cd
                    AND pst.lookup_type = 'CONTACT'
                    AND pst.INFORMATION3 = 'Y'
                    AND ( pst.business_group_id = pcr.business_group_id
                     OR   pst.business_group_id  IS NULL)
              );

Line: 180

select sum(date_end - date_start +1 ) duration
from per_absence_attendances
where person_id = p_person_id
and   abs_information_category = 'FR_M'
and   date_end < p_end_date
and   date_end > p_confinement_date
and   abs_information4 is null
and   abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id);

Line: 371

   SELECT global_value
   FROM ff_globals_f
   WHERE global_name = c_global_name
   AND legislation_code = 'FR'
   AND c_date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 379

select sum(date_end - date_start +1 ) duration
from per_absence_attendances
where person_id = p_person_id
and   abs_information_category = 'FR_M'
and   abs_information4 is null
and   date_start >= add_months(p_start_date,-9)
and   date_start < p_start_date
and   abs_information1 is null;

Line: 529

select min(effective_start_date) effective_start_date
,      max(effective_end_date) effective_end_date
,      min(creator_id) absence_id
from pay_element_entries_f
where element_entry_id = p_element_entry_id;

Line: 536

select
      paa.date_start
,     paa.date_end
,     paa.date_end - paa.date_start + 1 duration
,     paa.person_id
,     paa.abs_information_category
,     paa.abs_information1
,     paa.abs_information2
,     paa.abs_information3
,     paa.abs_information4
,     paa.abs_information5
,     paa.abs_information6
,     paa.abs_information7
,     paa.abs_information8
,     paa.abs_information9
,     paa.abs_information10
from per_absence_attendances paa
where paa.absence_attendance_id = p_absence_attendance_id;

Line: 556

SELECT    pabs.abs_information2 elig_gi,
          nvl(fnd_date.canonical_to_date (pabs.abs_information4),
                              hr_general.end_of_time) birth_date,
          fnd_number.canonical_to_number(pabs.abs_information6) births,
          pabs.abs_information7 estmtd_ijss,
          pabs.abs_information8 elig_ijss_hours,
          fnd_number.canonical_to_number (pabs.abs_information9)
                                              elig_ijss_contrib,
          pabs.date_start abs_start,
          pabs.date_end   abs_end
    FROM per_absence_attendances pabs
      WHERE pabs.absence_attendance_id = p_parent_absence_id;

Line: 572

select absence_attendance_id
,      date_start
,      date_end
,      date_end - date_start + 1 duration
from per_absence_attendances
where person_id = p_person_id
and   date_end <= p_max_end_date
and   abs_information1 = fnd_number.number_to_canonical(p_parent_absence_id)
order by date_start;

Line: 800

select paa.absence_attendance_id
,      paa.date_start
,      paa.date_end
,      decode(paa.abs_information_category,'FR_M',to_number(paa.abs_information1)) parent_absence_id
,      decode(paa.abs_information_category,'FR_M',NVL(paa.abs_information7,'N'),NVL(paa.abs_information4,'N')) estimated_ijss
from per_absence_attendances paa
     ,per_assignments_f paf
where paf.assignment_id = p_assignment_id
and   paf.person_id = paa.person_id
and   p_date_earned between
      paf.effective_start_date and paf.effective_end_date
and   p_payment_from_date between paa.date_start and paa.date_end
and   paa.abs_information_category IN ('FR_M','FR_FR_PATERNITY','FR_FR_ADOPTION');

Line: 815

select paa.abs_information7 estimated_ijss
from per_absence_attendances paa
where paa.absence_attendance_id = p_absence_attendance_id;

Line: 1077

      select decode(l_target_net,0,1,l_target_net) into l_init from dual;