APPS.PAY_PAYIEP30_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        MIN(PPA_ARC.START_DATE) START_DATE
      FROM
        PAY_ASSIGNMENT_ACTIONS PAA_P30,
        PAY_ACTION_INTERLOCKS PAI_P30,
        PAY_ASSIGNMENT_ACTIONS PAA_ARC,
        PAY_PAYROLL_ACTIONS PPA_ARC
      WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
        AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
        AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID
        AND PPA_ARC.PAYROLL_ACTION_ID = PAA_ARC.PAYROLL_ACTION_ID;

Line: 17

      SELECT
        SUBSTR(PPA_P30.LEGISLATIVE_PARAMETERS
              ,INSTR(PPA_P30.LEGISLATIVE_PARAMETERS
                   ,'END_DATE=') + 9
              ,10) END_DATE
      FROM
        PAY_PAYROLL_ACTIONS PPA_P30
      WHERE PPA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID;

Line: 26

      SELECT
        TO_DATE(RULE_MODE || '/' || TO_CHAR(VP_REPORT_END_DATE
                       ,'YYYY')
               ,'dd/mm/yyyy')
      FROM
        PAY_LEGISLATION_RULES
      WHERE LEGISLATION_CODE = 'IE'
        AND RULE_TYPE = 'L';

Line: 98

      SELECT
        ORG_INFORMATION9
      FROM
        HR_ORGANIZATION_INFORMATION
      WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
        AND ORG_INFORMATION9 is not null
        AND ORG_INFORMATION_CONTEXT = 'Business Group Information';

Line: 119

      SELECT
        CURRENCY_CODE
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;

Line: 151

      SELECT
        PACT_YTDBAL.ACTION_INFORMATION4 BALANCE_VALUE
      FROM
        PAY_ASSIGNMENT_ACTIONS PAA_P30,
        PAY_ACTION_INTERLOCKS PAI_P30,
        PAY_ASSIGNMENT_ACTIONS PAA_ARC,
        PAY_ACTION_INFORMATION PACT_YTDBAL,
        PAY_DEFINED_BALANCES PDB_YTDBAL,
        PAY_BALANCE_TYPES PBT_YTDBAL,
        PAY_BALANCE_DIMENSIONS PBD_YTDBAL,
        PAY_ASSIGNMENT_ACTIONS PAA_SRC,
        PAY_PAYROLL_ACTIONS PPA_SRC
      WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
        AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
        AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
        AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID
        AND PACT_YTDBAL.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
        AND PACT_YTDBAL.ACTION_CONTEXT_ID = VP_ACTION_CONTEXT_ID
        AND PACT_YTDBAL.ACTION_CONTEXT_ID = PAA_ARC.ASSIGNMENT_ACTION_ID
        AND PACT_YTDBAL.ACTION_CONTEXT_TYPE = 'AAP'
        AND PDB_YTDBAL.DEFINED_BALANCE_ID = PACT_YTDBAL.ACTION_INFORMATION1
        AND PDB_YTDBAL.BALANCE_TYPE_ID = PBT_YTDBAL.BALANCE_TYPE_ID
        AND PBT_YTDBAL.BALANCE_NAME = VP_BALANCE_NAME
        AND PBD_YTDBAL.DIMENSION_NAME = VP_DIMENSION_NAME
        AND PBD_YTDBAL.BALANCE_DIMENSION_ID = PDB_YTDBAL.BALANCE_DIMENSION_ID
        AND PBT_YTDBAL.LEGISLATION_CODE = 'IE'
        AND PACT_YTDBAL.ACTION_CONTEXT_TYPE = 'AAP'
        AND PAA_SRC.ASSIGNMENT_ACTION_ID = PACT_YTDBAL.SOURCE_ID
        AND PAA_SRC.PAYROLL_ACTION_ID = PPA_SRC.PAYROLL_ACTION_ID
        AND PPA_SRC.EFFECTIVE_DATE <= VP_EFFECTIVE_DATE
      ORDER BY
        PACT_YTDBAL.EFFECTIVE_DATE,
        PACT_YTDBAL.ACTION_CONTEXT_ID,
        NVL(PACT_YTDBAL.ACTION_INFORMATION5
           ,0);

Line: 187

      SELECT
        PPA.PAYROLL_ACTION_ID PREV_DATA_LOCK_ID,
        TO_DATE(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
                      ,INSTR(PPA.LEGISLATIVE_PARAMETERS
                           ,'END_DATE=') + 9
                      ,10)
               ,'YYYY/MM/DD')
      FROM
        PAY_PAYROLL_ACTIONS PPA,
        PAY_ASSIGNMENT_ACTIONS PAA
      WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
        AND PPA.REPORT_TYPE = 'IEP30_PRGLOCK'
        AND PAA.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
        AND PAA.ASSIGNMENT_ACTION_ID = (
        SELECT
          TO_NUMBER(SUBSTR(MAX(LPAD(PAA2.ACTION_SEQUENCE
                                   ,15
                                   ,'0') || PAA2.ASSIGNMENT_ACTION_ID)
                          ,16))
        FROM
          PAY_PAYROLL_ACTIONS PPA2,
          PAY_ASSIGNMENT_ACTIONS PAA2
        WHERE PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
          AND PPA2.REPORT_TYPE = 'IEP30_PRGLOCK'
          AND PAA2.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
          AND PPA2.PAYROLL_ACTION_ID <> VP_PAYROLL_ACTION_ID
          AND TO_DATE(SUBSTR(PPA2.LEGISLATIVE_PARAMETERS
                      ,INSTR(PPA2.LEGISLATIVE_PARAMETERS
                           ,'END_DATE=') + 9
                      ,10)
               ,'YYYY/MM/DD') BETWEEN VP_TAX_START_DATE
          AND VP_REPORT_END_DATE )
      ORDER BY
        PPA.PAYROLL_ACTION_ID;

Line: 222

      SELECT
        FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(PAA_RUN.ACTION_SEQUENCE
                                                      ,15
                                                      ,'0') || PACT_YTDBAL.ACTION_CONTEXT_ID)
                                             ,16))
      FROM
        PAY_ASSIGNMENT_ACTIONS PAA_P30,
        PAY_ACTION_INTERLOCKS PAI_P30,
        PAY_ASSIGNMENT_ACTIONS PAA_ARC,
        PAY_ACTION_INFORMATION PACT_YTDBAL,
        PAY_ACTION_INTERLOCKS PAI_ARC,
        PAY_ASSIGNMENT_ACTIONS PAA_RUN,
        PAY_PAYROLL_ACTIONS PPA_RUN
      WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
        AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
        AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
        AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID
        AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_ARC.LOCKING_ACTION_ID
        AND PACT_YTDBAL.ACTION_CONTEXT_ID = PAA_ARC.ASSIGNMENT_ACTION_ID
        AND PAA_RUN.ASSIGNMENT_ACTION_ID = PAI_ARC.LOCKED_ACTION_ID
        AND PACT_YTDBAL.ACTION_CONTEXT_TYPE = 'AAP'
        AND PAA_RUN.SOURCE_ACTION_ID IS NULL
        AND PAA_RUN.PAYROLL_ACTION_ID = PPA_RUN.PAYROLL_ACTION_ID
        AND PPA_RUN.ACTION_TYPE in ( 'R' , 'Q' );

Line: 414

      SELECT
        PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F
      WHERE PAYROLL_ID = VP_PAYROLL_ID;