APPS.PAY_PAYRP940_XMLP_PKG SQL Statements

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

Line: 13

    SELECT
      DECODE(COUNT(PAA.ASSIGNMENT_ID)
            ,0
            ,'F'
            ,'T')
    INTO P_FLAG
    FROM
      PAY_ASSIGNMENT_ACTIONS PAA,
      PAY_PAYROLL_ACTIONS PACT
    WHERE PACT.EFFECTIVE_DATE <= TO_DATE('31-12-' || P_TAX_YEAR
           ,'DD-MM-YYYY')
      AND PACT.EFFECTIVE_DATE >= TO_DATE('01-01-' || P_TAX_YEAR
           ,'DD-MM-YYYY')
      AND PACT.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
      AND PACT.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
      AND PACT.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' )
      AND PAA.TAX_UNIT_ID = P_TAX_UNIT_ID;

Line: 47

        SELECT
          ORG_INFORMATION2
        FROM
          HR_ORGANIZATION_INFORMATION
        WHERE ORGANIZATION_ID = TAX_UNIT_ID
          AND ORG_INFORMATION_CONTEXT = 'State Tax Rules'
          AND ORG_INFORMATION1 = STATE_CODE;

Line: 74

        SELECT
          D_TAX_OTD_VALUE,
          D_WAGE_OTD_VALUE,
          D_FORMAT_CODE
        FROM
          PAY_US_FEDERAL_TAX_BAL_GRE_V
        WHERE D_BALANCE_SET_NAME = '940_FED_YTD'
          AND D_TAX_UNIT_ID = P_TAX_UNIT_ID;

Line: 348

        SELECT
          ORG_INFORMATION6,
          ORG_INFORMATION7
        FROM
          HR_ORGANIZATION_INFORMATION
        WHERE ORGANIZATION_ID = TAX_UNIT_ID
          AND ORG_INFORMATION_CONTEXT = 'State Tax Rules'
          AND ORG_INFORMATION1 = STATE_CODE;

Line: 486

    CP_SELECT_COL1 := NULL;

Line: 487

    CP_SELECT_COL2 := NULL;

Line: 491

      CP_SELECT_COL1 := 'v.d_wage_otd_value ';

Line: 492

      CP_SELECT_COL2 := 'v.d_tax_unit_id ';

Line: 498

      CP_SELECT_COL1 := '1 ';

Line: 499

      CP_SELECT_COL2 := 'v.tax_unit_id ';

Line: 531

      SELECT
        DISTINCT
        SUBSTR(D_STATE_CODE
              ,1
              ,2),
        D_WAGE_OTD_VALUE
      FROM
        PAY_US_STATE_TAX_BAL_GRE_V
      WHERE D_STATE_CODE = '33-000-0000'
        AND D_BALANCE_SET_NAME = '940_STATE_YTD'
        AND D_TAX_TYPE = 'FUTA'
        AND D_TAX_UNIT_ID = TAX_UNIT_ID;