[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_ELEMENT_TYPE_EXTRA_INF_DFV

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      TYPE
,      ELEMENT_NAME
,      INSUFFICIENT_FUNDS_TYPE
,      PENSION_SCHEME_NAME
,      PENSION_PROVIDER
,      PENSION_TYPE
,      PENSION_CATEGORY
,      PENSION_YEAR_START_HU
,      EMPLOYEE_DEDUCTION_METHOD
,      EMPLOYER_DEDUCTION_METHOD
,      FUND_REFERENCE_NUMBER
,      EMPLOYEE_SUPPLEMENT
,      EMPLOYER_SUPPLEMENT
,      EMPLOYER_REFERENCE_NUMBER
,      SCHEME_PREFIX
,      EMPLOYEE_COMPONENT
,      PENSION_TYPE_ID
,      PENSION_PROVIDER_ID
,      PENSION_SCHEME_PREFIX
,      PENSION_SCHEME_REPORTING_NAME
,      PENSION_SCHEME_DATE
,      PRSA2_CERTIFICATE
,      TERMINATION_RULE
,      THIRD_PARTY
,      TYPE_OF_DEDUCTION
,      ELEMENT_CODE
,      LEGAL_EMPLOYER
,      INCLUDE_IN_REPORT
,      AMOUNT_INPUT_VALUE
,      PERCENTAGE_INPUT_VALUE
,      REFERENCE_NUMBER_INPUT_VALUE
,      DEDUCTION_BASIS_BALANCE
,      FROM_REPORTING_YEAR
,      TO_REPORTING_YEAR
,      REPORTING_CODE
,      ELEMENT_TYPE
,      INFORMATION_1_PROMPT
,      INFORMATION_1_INPUT_VALUE
,      INFORMATION_2_PROMPT
,      INFORMATION_2_INPUT_VALUE
,      INFORMATION_3_PROMPT
,      INFORMATION_3_INPUT_VALUE
,      INFORMATION_4_PROMPT
,      INFORMATION_4_INPUT_VALUE
,      INFORMATION_5_PROMPT
,      INFORMATION_5_INPUT_VALUE
,      INFORMATION_6_PROMPT
,      INFORMATION_6_INPUT_VALUE
,      INPUT_VALUE
,      SSB_CODE
,      SUMMARY___ADDITIONAL
,      DUMMY
,      ADDITIONAL_INFORMATION
,      TDS_TYPE_ON_BONUS
,      TDS_PERCENTAGE
,      IS_STATE
,      STATE
,      OVRD_GARN_MAX_WTHLDNG_DURATION
,      OVRD_FED_STATE_MIN_WAGE_RULE
,      OVRD_FED_STATE_MIN_WAGE_FACTOR
,      INFORMATION_TIME
,      ROTH_CONTRIBUTION
,      ROTH_USERRA
,      TAX_LEVEL
,      CALCULATION_METHOD
,      ARREARS_ALLOWED
,      PARTIAL__ALLOWED
,      PLAN_NAME
,      PLAN_DESCRIPTION
,      OMP_QUALIFYING_DATE_TYPE
,      PRIOR_TO_EWC_DURATION
,      PRIOR_TO_EWC_UOM
,      AVERAGE_EARNINGS_DURATION
,      AVERAGE_EARNINGS_UOM
,      AVERAGE_EARNINGS_BALANCE
,      ABSENCE_ENTITLEMENT_DAYS_TYPE
,      ABSENCE_ENTITLEMENT_PARAMETERS
,      ABSENCE_ENTITLEMENT_HOLIDAYS
,      DAILY_RATE_DIVISOR_TYPE
,      DAILY_RATE_DIVISOR_DAYS_TYPE
,      DAILY_RATE_DIVISOR_DURATION
,      PAY_COMPONENT_RATE_TYPE
,      PRIMARY_ABSENCE_ELEMENT
,      DEFAULT_WORK_PATTERN
,      ABSENCE_TYPE_LIST_NAME
,      ABSENCE_ENTITLEMENT_CAL_RULES
,      ABSENCE_ENTITLEMENT_LIST_NAME
,      ABSENCE_PAY_PLAN_CLASS
,      ABSENCE_PAY_PLAN_CATEGORY
,      SCHEME_CALENDAR_TYPE
,      SCHEME_CALENDAR_DURATION
,      SCHEME_CALENDAR_UOM
,      SCHEME_START_DATE
,      SCHEME_END_DATE
,      ABSENCE_DAYS
,      ABSENCE_ENTITLEMENT_SICK_LEAVE
,      ABSENCE_DAILY_RATE_CALCULATION
,      ABSENCE_DAILY_RATE_CALC_PERIOD
,      ABSENCE_DAILY_RATE_CALC_DURAT
,      PRIMARY_ABSENCE_INFO_ELE
,      ABSENCE_DEFAULT_WORK_PATTERN
,      ABSENCE_TYPES_LIST_NAME
,      ABSENCE_OVERLAP_RULE
,      DUAL_ROLLING_PERIOD_DURATION
,      DUAL_ROLLING_PERIOD_UOM
,      ENABLE_ENTITLEMENT_PRORATION
,      ABSENCE_SCHEDULE_WORK_PATTERN
,      PLAN_TYPES_TO_EXTEND_PERIOD
,      FULL_TIMER_ROUNDING_VALUES
,      PART_TIMER_ROUNDING_VALUES
,      PAYPNT
,      ALLCODE
,      ALLDESC
,      PENFLG
,      INDFLG
,      SBFLG
,      BASIC
,      PRE75
,      BONCODE
,      BONDESC
,      PENSION_YEAR_START_DATE
,      SCHEME_TYPE
,      SCON
,      ECON
,      SCHEME_NUMBER
,      BASE_PENSION_SCHEME
,      ADDITIONAL_CONTRIBUTIONS
,      ADDED_YEARS
,      FAMILY_OR_WIDOWER_BENEFIT
,      FAMILY_WIDOWER_ADDED_YEARS
,      ASSOCIATED_OCP_SCHEME
,      PENSIONABLE_SALARY_BALANCE
,      FAMILY_WIDOWER_ELEMENT_TYPE_ID
,      FAMILY_WIDOWER_FIX_ELE_TYPE_ID
,      DEDUCTION_METHOD
,      EMPLOYER_COMPONENT
,      ARREARAGE
,      PARTIAL_DEDUCTIONS
,      DATE_FROM
,      DATE_TO
,      PENSION_SUB_CATEGORY
,      CONVERSION_RULE
,      OHT_RULE_APPLICABLE
,      AFFECTED_BY_ABSENCES
,      PENSION_BASIS_CALCULATION_MTHD
,      PART_TIME_PERCENTAGE_CALC_
,      CURRENT_YEAR_EE_RETRO_ELEMENT
,      PREVIOUS_YEAR_EE_RETRO_ELEMENT
,      CURRENT_YEAR_ER_RETRO_ELEMENT
,      PREVIOUS_YEAR_ER_RETRO_ELEMENT
,      BASIS_ROUNDING
,      CONTRIBUTION_ROUNDING
,      PENSION_PLAN
,      SAVING_SCHEME_NAME
,      PROFESSIONAL_BODY_NAME
,      PROFESSIONAL_BODY_LEVEL_BAL
,      OVERRIDE_AMOUNT
,      THIRD_PARTY_PAYMENT
,      TIME_DIMENSION
,      PAY_SOURCE_VALUE
,      QUALIFIER
,      FTE
,      SERVICE_HISTORY
,      CALC_TYPE_DUMMY
,      CALCULATION_TYPE
,      CALCULATION_VALUE
,      INPUT_VALUE_NAME
,      LINK_TO_ASSIGN_DUMMY
,      LINKED_TO_ASSIGNMENT
,      TERM_TIME_FACTOR
,      SUM_MULTIPLE_ENTRIES
,      LOOKUP_INPUT_VALUES
,      TABLE_VALUES_DUMMY
,      COLUMN_NAME_SOURCE
,      COLUMN_NAME_QUALIFIER
,      ROW_NAME_SOURCE
,      ROW_NAME_QUALIFIER
,      RATE_TYPE_NAME
,      DESCRIPTION
,      UNION_NAME
,      UNION_LEVEL_BALANCE
,      RATE_TYPE
,      FUND_LIST
,      CATCH_UP_PROCESSING
,      SRS_PLAN_TYPE
,      BUY_BACK
,      VEHICLE_TYPE
,      SLIDING_SCALE_RATES
,      NEW_INPUT_VALUE
,      USE_ANNUALIZATION_HRS_CALC_TYP
,      PLAN_NUMBER
,      SOURCE
,      SUB_PLAN
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ELEMENT_TYPE_EXTRA_INF_DFV;

Dependencies

[top of page]

APPS

FND_NUMBER - show dependent code

PAY_ELEMENT_TYPE_EXTRA_INFO

PUBLIC

PAY_ELEMENT_TYPE_EXTRA_INF_DFV