APPS.PER_IN_ORG_INFO_LEG_HOOK SQL Statements

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

Line: 219

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information1 = p_org_info;

Line: 225

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information2 = p_org_info;

Line: 231

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information3 = p_org_info;

Line: 237

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information4 = p_org_info;

Line: 243

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information5 = p_org_info;

Line: 249

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
      AND   organization_id = p_organization_id
      AND   org_information6 = p_org_information6
      AND   org_information3 = p_org_info;

Line: 257

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
      AND   organization_id = p_organization_id
      AND   org_information6 = p_org_information6
      AND   org_information4 = p_org_info;

Line: 265

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_COMPANY_DF'
      AND   org_information5 = p_org_info;

Line: 271

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_CHALLAN_INFO'
      AND org_information12 = p_org_info;

Line: 277

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_SEC7Q_INFO'
      AND org_information11 = p_org_info;

Line: 283

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_CHN_SEC14B'
      AND org_information1 = p_org_info;

Line: 289

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = p_org_info_type_code
      AND org_information3 = p_org_info;

Line: 295

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_BANK_PAYMENT_DETAILS'
      AND   org_information5 = p_org_info;

Line: 301

     SELECT 'X'
     FROM hr_organization_information
     WHERE org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
     AND org_information1 = p_org_information1
     AND org_information2 = p_org_information2
     AND organization_id = p_organization_id;

Line: 726

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information1 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 733

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information2 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 740

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information3 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 747

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information4 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 754

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'IN_CONTRACTOR_INFO'
      AND   org_information5 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 761

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
      AND   org_information3 = p_org_info
      AND   org_information6 = p_org_information6
      AND   organization_id = p_organization_id
      AND   org_information_id <> p_org_information_id;

Line: 771

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
      AND   org_information4 = p_org_info
      AND   org_information6 = p_org_information6
      AND   organization_id = p_organization_id
      AND   org_information_id <> p_org_information_id;

Line: 780

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_COMPANY_DF'
      AND   org_information5 = p_org_info
       AND   org_information_id <> p_org_information_id;

Line: 787

       SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_CHALLAN_INFO'
      AND  org_information12 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 794

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_SEC7Q_INFO'
      AND org_information11 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 802

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_CHN_SEC14B'
      AND org_information1 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 809

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = p_org_info_type_code
      AND org_information3 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 816

      SELECT 'X'
      FROM hr_organization_information
      WHERE org_information_context = 'PER_IN_PF_BANK_PAYMENT_DETAILS'
      AND   org_information5 = p_org_info
      AND   org_information_id <> p_org_information_id;

Line: 823

     SELECT 'X'
     FROM hr_organization_information
     WHERE org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
     AND org_information1 = p_org_information1
     AND org_information2 = p_org_information2
     AND   org_information_id <> p_org_information_id
     AND organization_id = p_organization_id;

Line: 1372

  SELECT 'X'
    FROM hr_organization_information
   WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
     AND org_information1 = p_org_information1
     AND organization_id<>p_organization_id;

Line: 1385

  SELECT 'X'
    FROM hr_organization_information hoi
   WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
     AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
     AND organization_id=p_organization_id
     AND org_information_context=p_org_info_type_code;

Line: 1398

   SELECT 'X'
     FROM hr_organization_information hoi
         ,hr_organization_units hou
    WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
      AND hoi.org_information3 = p_org_information3
      AND hou.organization_id = hoi.organization_id
      AND hou.business_group_id = (SELECT business_group_id
                                     FROM hr_organization_units org
                                     WHERE org.organization_id = p_organization_id);

Line: 1652

   SELECT 'X'
     FROM hr_organization_information
    WHERE org_information_context = 'PER_IN_INCOME_TAX_DF'
      AND org_information1 = p_org_information1
      AND organization_id <>p_organization_id;

Line: 1662

   SELECT organization_id
     FROM hr_organization_information
    WHERE org_information_id =p_org_information_id;

Line: 1674

   SELECT 'X'
     FROM hr_organization_information hoi
    WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
      AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
      AND organization_id=p_organization_id
      AND org_information_id <>p_org_information_id
      AND org_information_context=p_org_info_type_code;

Line: 1684

   SELECT 'X'
     FROM hr_organization_information hoi
         ,hr_organization_units  hou
    WHERE hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
      AND hoi.org_information3 = p_challan_number
      AND hoi.org_information_id <> p_org_information_id
      AND hou.organization_id = hoi.organization_id
      AND hou.business_group_id  = (SELECT business_group_id
                                      FROM hr_organization_units org
                                     WHERE org.organization_id = p_organization_id) ;

Line: 2451

PROCEDURE check_organization_update
                (p_effective_date     IN  DATE,
                 p_organization_id    IN NUMBER,
                 p_name               IN VARCHAR2,
                 p_date_from          IN DATE,
                 p_date_to            IN DATE,
                 p_location_id        IN NUMBER)
IS
   CURSOR c_org_id IS
      SELECT organization_id
            ,name
            ,date_from
            ,date_to
            ,location_id
      FROM   hr_organization_units
      WHERE  organization_id = p_organization_id;

Line: 2479

  l_procedure := g_package||'check_organization_update';

Line: 2548

END check_organization_update;

Line: 2783

   SELECT org_information3
     FROM hr_organization_information hoi
    WHERE hoi.organization_id =p_organization_id
      AND hoi.org_information_context ='PER_IN_INCOME_TAX_DF';

Line: 2792

       SELECT COUNT(*)
         FROM hr_organization_information
        WHERE organization_id = p_organization_id
          AND org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
          AND org_information1 = p_org_information1
          AND org_information2 = p_org_information2
          AND org_information3 IS NOT NULL
          AND org_information5 = 'A'
          AND org_information6 = 'O'
          AND (p_org_information_id IS NULL
            OR p_org_information_id <> org_information_id);

Line: 2807

       SELECT COUNT(*)
         FROM hr_organization_information
        WHERE organization_id = p_organization_id
          AND org_information_context = 'PER_IN_FORM24Q_RECEIPT_DF'
          AND org_information1 = p_org_information1
          AND org_information2 = p_org_information2
          AND org_information3 IS NOT NULL
          AND org_information6 = 'O';

Line: 2820

       SELECT 'Y'
          FROM DUAL
         WHERE EXISTS
                (  SELECT 1
                     FROM hr_organization_information hoi
                         ,pay_element_entries_f pee
                         ,pay_element_types_f   pet
                    WHERE pet.element_name = 'Income Tax Challan Information'
                      AND pet.legislation_code = 'IN'
                      AND pee.element_type_id = pet.element_type_id
                      AND pay_in_utils.get_ee_value(pee.element_entry_id,'Challan or Voucher Number') = hoi.org_information3
                      AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
                      AND hoi.org_information_id = p_org_information_id
                      AND hoi.organization_id = p_organization_id
                      AND hoi.org_information3 <> p_org_information3
              );

Line: 3709

PROCEDURE check_org_info_update
                (p_effective_date     IN  DATE,
                 p_org_information_id IN  NUMBER,
                 p_org_info_type_code IN VARCHAR2,
                 p_org_information1   IN VARCHAR2,
                 p_org_information2   IN VARCHAR2,
                 p_org_information3   IN VARCHAR2,
                 p_org_information4   IN VARCHAR2,
                 p_org_information5   IN VARCHAR2,
                 p_org_information6   IN VARCHAR2,
                 p_org_information7   IN VARCHAR2,
                 p_org_information8   IN VARCHAR2,
                 p_org_information9   IN VARCHAR2,
                 p_org_information10  IN VARCHAR2,
                 p_org_information11  IN VARCHAR2,
                 p_org_information12  IN VARCHAR2,
                 p_org_information13  IN VARCHAR2,
                 p_org_information14  IN VARCHAR2,
                 p_org_information15  IN VARCHAR2,
                 p_org_information16  IN VARCHAR2,
                 p_org_information17  IN VARCHAR2,
                 p_org_information18  IN VARCHAR2,
                 p_org_information19  IN VARCHAR2,
                 p_org_information20  IN VARCHAR2)
IS

   CURSOR c_org_id IS
      SELECT organization_id
            ,org_information1
            ,org_information2
            ,org_information3
            ,org_information4
            ,org_information5
            ,org_information6
            ,org_information7
            ,org_information8
            ,org_information9
            ,org_information10
            ,org_information11
            ,org_information12
            ,org_information13
            ,org_information14
            ,org_information15
            ,org_information16
            ,org_information17
            ,org_information18
            ,org_information19
            ,org_information20
      FROM   hr_organization_information
      WHERE  org_information_id = p_org_information_id;

Line: 3787

  l_procedure := g_package||'check_org_info_update';

Line: 3977

END check_org_info_update;