APPS.PER_IN_PERSON_LEG_HOOK SQL Statements

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

Line: 114

 PROCEDURE check_unique_number_insert(
          p_per_information_category IN VARCHAR2
         ,p_business_group_id        IN NUMBER
         ,p_per_information4         IN VARCHAR2 DEFAULT NULL
         ,p_per_information8         IN VARCHAR2 DEFAULT NULL
         ,p_per_information9         IN VARCHAR2 DEFAULT NULL
         ,p_per_information10        IN VARCHAR2 DEFAULT NULL
         ,p_per_information11        IN VARCHAR2 DEFAULT NULL
         ,p_per_information12        IN VARCHAR2 DEFAULT NULL
         ,p_per_information13        IN VARCHAR2 DEFAULT NULL
        ) IS
BEGIN

NULL ;

Line: 129

END check_unique_number_insert;

Line: 164

PROCEDURE check_unique_number_update(
         p_effective_date           IN DATE
        ,p_per_information_category IN VARCHAR2
        ,p_person_id                IN NUMBER
        ,p_per_information4         IN VARCHAR2 DEFAULT NULL
        ,p_per_information8         IN VARCHAR2 DEFAULT NULL
        ,p_per_information9         IN VARCHAR2 DEFAULT NULL
        ,p_per_information10        IN VARCHAR2 DEFAULT NULL
        ,p_per_information11        IN VARCHAR2 DEFAULT NULL
        ,p_per_information12        IN VARCHAR2 DEFAULT NULL
        ,p_per_information13        IN VARCHAR2 DEFAULT NULL
        ) IS
BEGIN

NULL ;

Line: 180

END check_unique_number_update;

Line: 361

     SELECT NVL(org_information3,'Y') FROM hr_organization_information
     WHERE  organization_id = p_business_group_id
     AND    ORG_INFORMATION_CONTEXT = 'PER_IN_STAT_SETUP_DF';

Line: 367

      SELECT 1 FROM per_people_f
            WHERE business_group_id = p_business_group_id
            AND per_information_category = 'IN'
                AND (person_id <> p_person_id OR p_person_id is null)
                AND decode(p_field,'PAN',per_information4
                                  ,'PF Number',per_information8
                                  ,'ESI Number',per_information9
                                  ,'Super Annuation Number',per_information10
                                  ,'Group Insurance Number',per_information11
                                  ,'Gratuity Number',per_information12
                                  ,'Pension Number',per_information13
                                  ,'PAN Reference Number',per_information14
				  ,'NSSN',per_information15) = p_value;

Line: 734

   SELECT system_person_type
   FROM   per_person_types
   WHERE  business_group_id = p_business_group_id
   AND    person_type_id = p_person_type_id;

Line: 741

  SELECT ppt.system_person_type
    FROM per_person_type_usages_f pptu
        ,per_person_types   ppt
  WHERE  pptu.person_type_id  = ppt.person_type_id
    AND  pptu.person_id       = p_person_id
    AND  ppt.business_group_id = p_business_group_id
    AND  p_effective_date BETWEEN pptu.effective_start_date
    AND  pptu.effective_end_date;

Line: 1296

PROCEDURE check_in_person_insert
        (
         p_per_information_category IN VARCHAR2
        ,p_business_group_id        IN NUMBER
        ,p_person_type_id           IN NUMBER
        ,p_hire_date                IN DATE
        ,p_per_information4         IN VARCHAR2
        ,p_per_information5         IN VARCHAR2
        ,p_per_information6         IN VARCHAR2
        ,p_per_information7         IN VARCHAR2
        ,p_per_information8         IN VARCHAR2
        ,p_per_information9         IN VARCHAR2
        ,p_per_information10        IN VARCHAR2
        ,p_per_information11        IN VARCHAR2
        ,p_per_information12        IN VARCHAR2
        ,p_per_information13        IN VARCHAR2
        ,p_per_information14        IN VARCHAR2
        ,p_per_information15        IN VARCHAR2
        )

IS
   l_procedure    VARCHAR2(100);

Line: 1325

   l_procedure := g_package||'check_in_person_insert';

Line: 1385

END check_in_person_insert;

Line: 1427

PROCEDURE check_in_person_update
        (
         p_per_information_category IN VARCHAR2
        ,p_person_type_id           IN NUMBER
        ,p_person_id                IN NUMBER
        ,p_effective_date           IN DATE
        ,p_per_information4         IN VARCHAR2
        ,p_per_information5         IN VARCHAR2
        ,p_per_information6         IN VARCHAR2
        ,p_per_information7         IN VARCHAR2
        ,p_per_information8         IN VARCHAR2
        ,p_per_information9         IN VARCHAR2
        ,p_per_information10        IN VARCHAR2
        ,p_per_information11        IN VARCHAR2
        ,p_per_information12        IN VARCHAR2
        ,p_per_information13        IN VARCHAR2
        ,p_per_information14        IN VARCHAR2
        ,p_per_information15        IN VARCHAR2
        )


IS
       l_procedure               VARCHAR2(100);

Line: 1455

      SELECT per_information4
            ,per_information5
            ,per_information6
            ,per_information7
            ,per_information8
            ,per_information9
            ,per_information10
            ,per_information11
            ,per_information12
            ,per_information13
            ,per_information14
            ,per_information15
            ,business_group_id
      FROM  per_people_f
      WHERE p_effective_date BETWEEN effective_start_date
                             AND effective_end_date
      AND   person_id = p_person_id;

Line: 1488

   l_procedure := g_package||'check_in_person_update';

Line: 1614

END check_in_person_update;