APPS.HR_NL_EXTRA_PERSON_RULES SQL Statements

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

Line: 63

PROCEDURE fdr_update_check
 ( P_PERSON_ID per_all_people_f.person_id%TYPE
 , P_DATE_OF_BIRTH date
 , P_PER_INFORMATION1 varchar2
 , P_PRE_NAME_ADJUNCT per_all_people_f.PRE_NAME_ADJUNCT%TYPE default ' '
 , P_LAST_NAME per_all_people_f.LAST_NAME%TYPE
 , P_EFFECTIVE_DATE date default to_date('01/01/4712','DD/MM/YYYY')
 , P_NATIONAL_IDENTIFIER per_all_people_f.NATIONAL_IDENTIFIER%TYPE
 , P_EMPLOYEE_NUMBER per_all_people_f.EMPLOYEE_NUMBER%TYPE) IS

   l_hiredate date;

Line: 86

    SELECT count(*)
     FROM PER_PEOPLE_EXTRA_INFO
     WHERE PERSON_ID = p_csr_person_id
     AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'
     AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
     AND upper(pei_information2) = 'Y';

Line: 95

    SELECT DATE_OF_BIRTH
          ,PER_INFORMATION1
          ,PRE_NAME_ADJUNCT
          ,LAST_NAME
          ,NATIONAL_IDENTIFIER
          ,EMPLOYEE_NUMBER
     FROM per_all_people_f
     WHERE person_id = p_csr_person_id
     AND  P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
                               AND EFFECTIVE_END_DATE
     AND business_group_id in (SELECT business_group_id
                               FROM per_business_groups
                               WHERE legislation_code = 'NL');

Line: 173

   END fdr_update_check;

Line: 183

    SELECT count(*)
     FROM PER_PEOPLE_EXTRA_INFO
     WHERE PERSON_ID = p_csr_person_id
     AND INFORMATION_TYPE = 'NL_FIRST_DAY_REPORT'
     AND PEI_INFORMATION_CATEGORY = 'NL_FIRST_DAY_REPORT'
     AND upper(pei_information2) = 'Y';