APPS.PAY_PYIEBIKA_XMLP_PKG SQL Statements

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

Line: 7

      SELECT
        PDB.DEFINED_BALANCE_ID
      FROM
        PAY_BALANCE_DIMENSIONS PBD,
        PAY_BALANCE_TYPES PBT,
        PAY_DEFINED_BALANCES PDB
      WHERE PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
        AND PBT.BALANCE_NAME = L_BALANCE_NAME
        AND PBD.BALANCE_DIMENSION_ID = PDB.BALANCE_DIMENSION_ID
        AND PBD.DATABASE_ITEM_SUFFIX = '_ASG_TWO_YTD'
        AND PBT.LEGISLATION_CODE = 'IE';

Line: 22

    SELECT
      NAME
    INTO
      CP_BUSINESS_GROUP_NAME
    FROM
      PER_BUSINESS_GROUPS
    WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;

Line: 68

      SELECT
        PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F
      WHERE PAYROLL_ID = VP_PAYROLL_ID;