APPS.PER_PERDETBU_XMLP_PKG SQL Statements

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

Line: 10

    INSERT INTO FND_SESSIONS
      (SESSION_ID
      ,EFFECTIVE_DATE)
    VALUES   (USERENV('SESSIONID')
      ,P_DATE_FROM);

Line: 17

        SELECT
          DISTINCT
          POSE.ORGANIZATION_ID_PARENT
        INTO L_TOP_ORG_ID
        FROM
          PER_ORG_STRUCTURE_ELEMENTS POSE,
          PER_ORG_STRUCTURE_VERSIONS POSV
        WHERE POSE.ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
          AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY
          AND POSV.VERSION_NUMBER = (
          SELECT
            MAX(VERSION_NUMBER)
          FROM
            PER_ORG_STRUCTURE_VERSIONS POSV
          WHERE POSV.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
            AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY )
          AND POSE.ORGANIZATION_ID_PARENT not in (
          SELECT
            POSE.ORGANIZATION_ID_CHILD
          FROM
            PER_ORG_STRUCTURE_ELEMENTS POSE,
            PER_ORG_STRUCTURE_VERSIONS POSV
          WHERE POSE.ORG_STRUCTURE_VERSION_ID = POSV.ORG_STRUCTURE_VERSION_ID
            AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY
            AND POSV.VERSION_NUMBER = (
            SELECT
              MAX(VERSION_NUMBER)
            FROM
              PER_ORG_STRUCTURE_VERSIONS POSV
            WHERE POSV.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
              AND POSV.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY ) );

Line: 55

    HR_DE_TAX_SUPPORT.BATCH_UPDATE(P_BUSINESS_GROUP_ID
                                  ,P_DATE_FROM
                                  ,P_ORG_HIERARCHY
                                  ,P_TOP_ORG
                                  ,P_ASSIGNMENT_SET
                                  ,P_ACTION
                                  ,P_CONC_REQUEST_ID
                                  ,P_TAX_CLASS
                                  ,P_NU_CHILDREN
                                  ,P_TAXFREE_INCOME
                                  ,P_ADD_TAX_INCOME);

Line: 67

      INSERT INTO FND_SESSIONS
        (SESSION_ID
        ,EFFECTIVE_DATE)
      VALUES   (USERENV('SESSIONID')
        ,P_DATE_FROM - 1);

Line: 79

      HR_DE_TAX_SUPPORT.DELETE_ASSIGNMENT(P_CONC_REQUEST_ID);

Line: 90

      SELECT
        DISTINCT
        TAX_CLASS
      INTO L_TAX_CLASS
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_TAX_CLASSFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);

Line: 100

      SELECT
        DISTINCT
        TAX_CLASS
      INTO L_TAX_CLASS
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
        AND NVL(HDTV.EFFECTIVE_END_DATE
         ,P_DATE_FROM);

Line: 122

      SELECT
        DISTINCT
        NO_OF_CHILDREN
      INTO L_OLD_NOC
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_NOCFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);

Line: 132

      SELECT
        DISTINCT
        NO_OF_CHILDREN
      INTO L_OLD_NOC
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
        AND NVL(HDTV.EFFECTIVE_END_DATE
         ,P_DATE_FROM);

Line: 154

      SELECT
        DISTINCT
        MONTHLY_TAX_FREE_INCOME
      INTO L_OLD_MTFI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_MTFIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);

Line: 164

      SELECT
        DISTINCT
        MONTHLY_TAX_FREE_INCOME
      INTO L_OLD_MTFI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
        AND NVL(HDTV.EFFECTIVE_END_DATE
         ,P_DATE_FROM);

Line: 186

      SELECT
        DISTINCT
        YEARLY_TAX_FREE_INCOME
      INTO L_OLD_YTFI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_YTFIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);

Line: 196

      SELECT
        DISTINCT
        YEARLY_TAX_FREE_INCOME
      INTO L_OLD_YTFI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
        AND NVL(HDTV.EFFECTIVE_END_DATE
         ,P_DATE_FROM);

Line: 218

      SELECT
        DISTINCT
        ADDITIONAL_MTH_TAXABLE_INCOME
      INTO L_OLD_AMTI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_AMTIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);

Line: 228

      SELECT
        DISTINCT
        ADDITIONAL_MTH_TAXABLE_INCOME
      INTO L_OLD_AMTI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
        AND NVL(HDTV.EFFECTIVE_END_DATE
         ,P_DATE_FROM);

Line: 250

      SELECT
        DISTINCT
        ADDITIONAL_YEAR_TAXABLE_INCOME
      INTO L_OLD_AYTI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_OLD_AYTIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID <> TO_CHAR(P_CONC_REQUEST_ID);

Line: 260

      SELECT
        DISTINCT
        ADDITIONAL_YEAR_TAXABLE_INCOME
      INTO L_OLD_AYTI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
        AND NVL(HDTV.EFFECTIVE_END_DATE
         ,P_DATE_FROM);

Line: 282

      SELECT
        DISTINCT
        TAX_CLASS
      INTO L_TAX_CLASS
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_TAX_CLASSFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);

Line: 293

        SELECT
          DISTINCT
          TAX_CLASS
        INTO L_TAX_CLASS
        FROM
          HR_DE_TAX_INFORMATION_V HDTV
        WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
          AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
          AND NVL(HDTV.EFFECTIVE_END_DATE
           ,P_DATE_FROM);

Line: 318

      SELECT
        DISTINCT
        NO_OF_CHILDREN
      INTO L_NEW_NOC
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_NOCFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);

Line: 329

        SELECT
          DISTINCT
          NO_OF_CHILDREN
        INTO L_NEW_NOC
        FROM
          HR_DE_TAX_INFORMATION_V HDTV
        WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
          AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
          AND NVL(HDTV.EFFECTIVE_END_DATE
           ,P_DATE_FROM);

Line: 354

      SELECT
        DISTINCT
        YEARLY_TAX_FREE_INCOME
      INTO L_NEW_YTFI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_YTFIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);

Line: 365

        SELECT
          DISTINCT
          YEARLY_TAX_FREE_INCOME
        INTO L_NEW_YTFI
        FROM
          HR_DE_TAX_INFORMATION_V HDTV
        WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
          AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
          AND NVL(HDTV.EFFECTIVE_END_DATE
           ,P_DATE_FROM);

Line: 390

      SELECT
        DISTINCT
        ADDITIONAL_YEAR_TAXABLE_INCOME
      INTO L_NEW_AYTI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_AYTIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);

Line: 401

        SELECT
          DISTINCT
          ADDITIONAL_YEAR_TAXABLE_INCOME
        INTO L_NEW_AYTI
        FROM
          HR_DE_TAX_INFORMATION_V HDTV
        WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
          AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
          AND NVL(HDTV.EFFECTIVE_END_DATE
           ,P_DATE_FROM);

Line: 426

      SELECT
        DISTINCT
        ADDITIONAL_MTH_TAXABLE_INCOME
      INTO L_NEW_AMTI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_AMTIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);

Line: 437

        SELECT
          DISTINCT
          ADDITIONAL_MTH_TAXABLE_INCOME
        INTO L_NEW_AMTI
        FROM
          HR_DE_TAX_INFORMATION_V HDTV
        WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
          AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
          AND NVL(HDTV.EFFECTIVE_END_DATE
           ,P_DATE_FROM);

Line: 462

      SELECT
        DISTINCT
        MONTHLY_TAX_FREE_INCOME
      INTO L_NEW_MTFI
      FROM
        HR_DE_TAX_INFORMATION_V HDTV
      WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
        AND HDTV.ELEMENT_ENTRY_ID = CF_NEW_MTFIFORMULA.ELEMENT_ENTRY_ID
        AND HDTV.PROCESS_ID = TO_CHAR(P_CONC_REQUEST_ID);

Line: 473

        SELECT
          DISTINCT
          MONTHLY_TAX_FREE_INCOME
        INTO L_NEW_MTFI
        FROM
          HR_DE_TAX_INFORMATION_V HDTV
        WHERE HDTV.ASSIGNMENT_ID = ASSIGNMENT_ID1
          AND P_DATE_FROM BETWEEN HDTV.EFFECTIVE_START_DATE
          AND NVL(HDTV.EFFECTIVE_END_DATE
           ,P_DATE_FROM);