APPS.PAY_PAYAUSOE_XMLP_PKG SQL Statements

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

Line: 23

      SELECT
        EFFECTIVE_DATE
      FROM
        PAY_PAYROLL_ACTIONS
      WHERE PAYROLL_ACTION_ID = PAYROLL_ACT_ID;

Line: 51

      SELECT
        1
      FROM
        PAY_ACCRUAL_PLANS AP,
        PAY_ELEMENT_TYPES_F ET,
        PAY_ELEMENT_LINKS_F EL,
        PAY_ELEMENT_ENTRIES_F EE,
        PAY_ASSIGNMENT_ACTIONS AA,
        PAY_PAYROLL_ACTIONS PA,
        PER_ABSENCE_ATTENDANCE_TYPES PAAT,
        PER_TIME_PERIODS TP
      WHERE AA.ASSIGNMENT_ACTION_ID = R_ASG_ASSIGNMENT_ACTION_ID
        AND AP.ACCRUAL_CATEGORY = 'AUAL'
        AND ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
        AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
        AND EE.ELEMENT_LINK_ID = EL.ELEMENT_LINK_ID
        AND AA.ASSIGNMENT_ID = EE.ASSIGNMENT_ID
        AND PA.PAYROLL_ACTION_ID = AA.PAYROLL_ACTION_ID
        AND TP.PAYROLL_ID = PA.PAYROLL_ID
        AND PAAT.INPUT_VALUE_ID = AP.PTO_INPUT_VALUE_ID
        AND PA.EFFECTIVE_DATE between TP.START_DATE
        AND TP.END_DATE
        AND PAAT.ABSENCE_ATTENDANCE_TYPE_ID = (
        SELECT
          MAX(PAAT1.ABSENCE_ATTENDANCE_TYPE_ID)
        FROM
          PER_ABSENCE_ATTENDANCE_TYPES PAAT1
        WHERE PAAT1.INPUT_VALUE_ID = AP.PTO_INPUT_VALUE_ID )
        AND PA.EFFECTIVE_DATE between ET.EFFECTIVE_START_DATE
        AND ET.EFFECTIVE_END_DATE
        AND PA.EFFECTIVE_DATE between EL.EFFECTIVE_START_DATE
        AND EL.EFFECTIVE_END_DATE
        AND PA.EFFECTIVE_DATE between EE.EFFECTIVE_START_DATE
        AND EE.EFFECTIVE_END_DATE;

Line: 297

      SELECT
        PTP.START_DATE
      FROM
        PAY_ASSIGNMENT_ACTIONS PAC,
        PAY_PAYROLL_ACTIONS PPA,
        PER_TIME_PERIODS PTP
      WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
        AND PAC.SOURCE_ACTION_ID is null
        AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
        AND PPA.DATE_EARNED between PTP.START_DATE
        AND PTP.END_DATE
        AND PAC.ASSIGNMENT_ACTION_ID = (
        SELECT
          MIN(PAI.LOCKED_ACTION_ID)
        FROM
          PAY_ACTION_INTERLOCKS PAI
        WHERE PAI.LOCKING_ACTION_ID = ASSIGNMENT_ACTION_ID_V );

Line: 329

    SELECT
      count(*)
    INTO L_GRADE_STEP
    FROM
      PER_SPINAL_POINT_STEPS_F PSP,
      PER_SPINAL_POINT_PLACEMENTS_F PSPP,
      PER_SPINAL_POINT_STEPS_F PSP2
    WHERE PSP.SEQUENCE >= PSP2.SEQUENCE
      AND PSPP.STEP_ID = PSP.STEP_ID
      AND PSPP.ASSIGNMENT_ID = CF_GRADE_STEPFORMULA.ASSIGNMENT_ID
      AND PSP.GRADE_SPINE_ID = PSP2.GRADE_SPINE_ID
      AND PSPP.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
      AND PSP.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
      AND PSP2.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
      AND CF_GRADE_STEPFORMULA.DATE_EARNED between PSP.EFFECTIVE_START_DATE
      AND PSP.EFFECTIVE_END_DATE
      AND CF_GRADE_STEPFORMULA.DATE_EARNED between PSPP.EFFECTIVE_START_DATE
      AND PSPP.EFFECTIVE_END_DATE
      AND CF_GRADE_STEPFORMULA.DATE_EARNED between PSP2.EFFECTIVE_START_DATE
      AND PSP2.EFFECTIVE_END_DATE;