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: 1383

  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: 1396

  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: 1409

  SELECT bank.org_information4
    FROM hr_organization_information bank
   WHERE bank.org_information_context = 'PER_IN_CHALLAN_BANK'
     AND  p_org_information5 = bank.org_information_id ;

Line: 1415

   SELECT 'X'
     FROM hr_organization_units hou
         ,hr_organization_information hoi
    WHERE hoi.organization_id   = hou.organization_id
      AND hou.business_group_id = (SELECT business_group_id
                         FROM hr_organization_units org
                         WHERE org.organization_id = p_organization_id)
      AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
      AND hoi.org_information3 = p_org_information3
      AND hoi.org_information2= p_org_information2
      and ((p_org_information5 is not null and
           p_bsr_code  in (SELECT bank.org_information4
                 FROM hr_organization_units hou
                     ,hr_organization_information bank
                WHERE hoi.organization_id   = hou.organization_id
                  AND hou.business_group_id = (SELECT business_group_id
                         FROM hr_organization_units org
                         WHERE org.organization_id = p_organization_id)
                  AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
                  AND bank.org_information_context = 'PER_IN_CHALLAN_BANK'
                  AND bank.organization_id = hoi.organization_id
                  AND hoi.org_information5 = bank.org_information_id )) or
	   p_org_information5 is  null);

Line: 1855

   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: 1865

   SELECT organization_id
     FROM hr_organization_information
    WHERE org_information_id =p_org_information_id;

Line: 1877

   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: 1887

 SELECT bank.org_information4
                 FROM hr_organization_information bank
                WHERE bank.org_information_context = 'PER_IN_CHALLAN_BANK'
                 AND  p_org_information5 = bank.org_information_id ;

Line: 1898

   SELECT 'X'
     FROM hr_organization_units hou
         ,hr_organization_information hoi
    WHERE hoi.organization_id   = hou.organization_id
      AND hou.business_group_id = (SELECT business_group_id
                         FROM hr_organization_units org
                         WHERE org.organization_id = p_organization_id)
      AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
      and ((p_org_information5 is not null and
           p_bsr_code  in (SELECT bank.org_information4
                 FROM hr_organization_units hou
                     ,hr_organization_information bank
                WHERE hoi.organization_id   = hou.organization_id
                  AND hou.business_group_id = (SELECT business_group_id
                         FROM hr_organization_units org
                         WHERE org.organization_id = p_organization_id)
                  AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
                  AND bank.org_information_context = 'PER_IN_CHALLAN_BANK'
                  AND bank.organization_id = hoi.organization_id
                  AND hoi.org_information5 = bank.org_information_id )) or
	   p_org_information5 is  null)
      AND hoi.org_information3 = p_challan_number /*Challan */
      AND hoi.org_information2 = p_org_information2 /* date */
      AND hoi.org_information_id <> p_org_information_id;

Line: 2841

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: 2869

  l_procedure := g_package||'check_organization_update';

Line: 2938

END check_organization_update;

Line: 3173

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

Line: 3182

       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: 3197

       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: 3211

       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')  like '% - %'||hoi.org_information3||'% - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')
                      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 OR hoi.org_information2 <> p_org_information2)
              );

Line: 4115

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: 4193

  l_procedure := g_package||'check_org_info_update';

Line: 4383

END check_org_info_update;