APPS.PAY_PAYGBTPL_XMLP_PKG SQL Statements

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

Line: 9

      SELECT
        PIV_SCON.INPUT_VALUE_ID SCON_IV,
        PIV_CAT.INPUT_VALUE_ID CAT_IV,
        PET.ELEMENT_TYPE_ID
      FROM
        PAY_INPUT_VALUES_F PIV_SCON,
        PAY_INPUT_VALUES_F PIV_CAT,
        PAY_ELEMENT_TYPES_F PET
      WHERE PET.ELEMENT_NAME = 'NI'
        AND PET.LEGISLATION_CODE = 'GB'
        AND PIV_SCON.NAME = 'SCON'
        AND PET.LEGISLATION_CODE = PIV_SCON.LEGISLATION_CODE
        AND PIV_SCON.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
        AND PIV_CAT.NAME = 'Category'
        AND PET.LEGISLATION_CODE = PIV_CAT.LEGISLATION_CODE
        AND PIV_CAT.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID;

Line: 34

      SELECT
        TO_DATE('06-04-' || TO_CHAR(TO_NUMBER(TO_CHAR(PTP.REGULAR_PAYMENT_DATE
                                         ,'YYYY')) + DECODE(SIGN(PTP.REGULAR_PAYMENT_DATE - TO_DATE('06-04-' || TO_CHAR(PTP.REGULAR_PAYMENT_DATE
                                                   ,'YYYY')
                                           ,'DD-MM-YYYY'))
                              ,-1
                              ,-1
                              ,0))
               ,'DD-MM-YYYY')
      INTO C_TY_START
      FROM
        PER_TIME_PERIODS PTP
      WHERE PTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID;

Line: 51

    SELECT
      BALANCE_DIMENSION_ID
    INTO C_YTD_BAL_DIM_ID
    FROM
      PAY_BALANCE_DIMENSIONS
    WHERE DIMENSION_NAME = '_ASG_TD_YTD'
      AND LEGISLATION_CODE = 'GB';

Line: 58

    SELECT
      BALANCE_DIMENSION_ID
    INTO C_PTD_BAL_DIM_ID
    FROM
      PAY_BALANCE_DIMENSIONS
    WHERE DIMENSION_NAME = '_ASG_TRANSFER_PTD'
      AND LEGISLATION_CODE = 'GB';

Line: 65

    SELECT
      BALANCE_DIMENSION_ID
    INTO L_PROC_PTD_DIM
    FROM
      PAY_BALANCE_DIMENSIONS
    WHERE DIMENSION_NAME = '_ASG_PROC_PTD'
      AND LEGISLATION_CODE = 'GB';

Line: 135

      SELECT
        CONSOLIDATION_SET_NAME
      INTO C_CONSOLIDATION_SET
      FROM
        PAY_CONSOLIDATION_SETS
      WHERE CONSOLIDATION_SET_ID = P_CONSOLIDATION_SET_ID;

Line: 172

      SELECT
        ELEMENT_TYPE_ID
      FROM
        PAY_ELEMENT_TYPES_F
      WHERE ELEMENT_NAME = 'PAYE';

Line: 178

      SELECT
        INPUT_VALUE_ID
      FROM
        PAY_INPUT_VALUES_F
      WHERE ELEMENT_TYPE_ID = L_PAYE_ELEMENT_ID
        AND NAME = P_IPV_NAME;

Line: 185

      SELECT
        RESULT_VALUE
      FROM
        PAY_RUN_RESULT_VALUES
      WHERE RUN_RESULT_ID = L_MAX_RUN_RESULT_ID
        AND INPUT_VALUE_ID = P_IPV_ID;

Line: 192

      SELECT
        TO_NUMBER(SUBSTR(MAX(LPAD(ASSACT2.ACTION_SEQUENCE
                                 ,15
                                 ,'0') || R2.SOURCE_TYPE || R2.RUN_RESULT_ID)
                        ,17))
      FROM
        PAY_ASSIGNMENT_ACTIONS ASSACT2,
        PAY_PAYROLL_ACTIONS PACT,
        PAY_RUN_RESULTS R2
      WHERE ASSACT2.ASSIGNMENT_ID = L_ASSIGNMENT_ID
        AND R2.ELEMENT_TYPE_ID + 0 = L_PAYE_ELEMENT_ID
        AND R2.ASSIGNMENT_ACTION_ID = ASSACT2.ASSIGNMENT_ACTION_ID
        AND R2.STATUS IN ( 'P' , 'PA' )
        AND PACT.PAYROLL_ACTION_ID = ASSACT2.PAYROLL_ACTION_ID
        AND PACT.ACTION_TYPE IN ( 'Q' , 'R' , 'B' , 'I' )
        AND ASSACT2.ACTION_STATUS = 'C'
        AND PACT.EFFECTIVE_DATE <= END_DATE_P
        AND PACT.EFFECTIVE_DATE >= ( TO_DATE('06-04-' || TO_CHAR(TO_NUMBER(TO_CHAR(L_REGULAR_PAYMENT_DATE
                                       ,'YYYY')) + DECODE(SIGN(L_REGULAR_PAYMENT_DATE - TO_DATE('06-04-' || TO_CHAR(L_REGULAR_PAYMENT_DATE
                                                 ,'YYYY')
                                         ,'DD-MM-YYYY'))
                            ,-1
                            ,-1
                            ,0))
             ,'DD-MM-YYYY') )
        AND NOT EXISTS (
        SELECT
          '1'
        FROM
          PAY_ACTION_INTERLOCKS PAI,
          PAY_ASSIGNMENT_ACTIONS ASSACT3,
          PAY_PAYROLL_ACTIONS PACT3
        WHERE PAI.LOCKED_ACTION_ID = ASSACT2.ASSIGNMENT_ACTION_ID
          AND PAI.LOCKING_ACTION_ID = ASSACT3.ASSIGNMENT_ACTION_ID
          AND PACT3.PAYROLL_ACTION_ID = ASSACT3.PAYROLL_ACTION_ID
          AND PACT3.ACTION_TYPE = 'V'
          AND ASSACT3.ACTION_STATUS = 'C' );

Line: 312

    SELECT
      PPA.EFFECTIVE_DATE,
      PPA.TIME_PERIOD_ID
    INTO L_ACTION_EFFECTIVE,L_TIME_PERIOD_ID
    FROM
      PAY_PAYROLL_ACTIONS PPA,
      PAY_ASSIGNMENT_ACTIONS PAA
    WHERE PAA.ASSIGNMENT_ACTION_ID = ASG_ACTION_ID
      AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID;

Line: 321

    SELECT
      PTP.START_DATE,
      PTP.REGULAR_PAYMENT_DATE
    INTO L_PERIOD_START,L_PERIOD_END
    FROM
      PER_TIME_PERIODS PTP
    WHERE PTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID;

Line: 442

    SELECT
      PDB.DEFINED_BALANCE_ID
    INTO T_DEF_BAL_ID
    FROM
      PAY_DEFINED_BALANCES PDB,
      PAY_BALANCE_TYPES PBT
    WHERE PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
      AND PBT.BALANCE_NAME = P_BALANCE_NAME
      AND PBT.LEGISLATION_CODE = 'GB'
      AND PBT.BUSINESS_GROUP_ID is null
      AND PDB.BALANCE_DIMENSION_ID = P_DIMENSION_ID
      AND PDB.BUSINESS_GROUP_ID is null
      AND PDB.LEGISLATION_CODE = 'GB';

Line: 502

    SELECT
      BPTP.REGULAR_PAYMENT_DATE,
      BPTPT.NUMBER_PER_FISCAL_YEAR
    INTO V_REG_PAY_DATE,V_NO_PER_FISC
    FROM
      PER_TIME_PERIODS BPTP,
      PER_TIME_PERIOD_TYPES BPTPT
    WHERE BPTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID
      AND BPTP.PERIOD_TYPE = BPTPT.PERIOD_TYPE;