[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_ELEMENT_ENTRIES_F_DFV

Object Details

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CONTEXT_VALUE
,      LAST_UPDATE_DATE
,      ATTACHMENT_PRIORITY
,      ATTACHABLE_EARNINGS_RULE
,      PRORATE_ON_INSUFFICIENT_FUNDS
,      DATE_SERVED
,      DEDUCTION_TYPE
,      DEDUCTION_BASIS
,      DEDUCTION_PERCENTAGE
,      DEDUCTION_AMOUNT_PER_RUN
,      DEDUCTION_CAP_PERIOD
,      DEDUCTION_CAP_MONTH
,      DEDUCTION_TERMINATION_RULE
,      DEDUCTION_TOTAL_OWED
,      DURATION__NO_OF_WEEKS_MONTHS_
,      FEE_FIRST_DEDUCTION_AMT
,      FEE_BASIS
,      FEE_PERCENTAGE
,      FEE_AMOUNT_PER_RUN
,      FEE_CAP_PERIOD
,      FEE_CAP_MONTH
,      EXEMPTION_BASIS
,      EXEMPTION_PERCENTAGE
,      EXEMPTION_MINIMUM_AMT
,      EXEMPTION_MAXIMUM_AMT
,      OVERRIDE_CONTRIBUTION_AREA
,      EE_PERCENT_OR_FIXED
,      EE_RATE_OR_FIXED_AMOUNT
,      ER_PERCENT_OR_FIXED
,      ER_RATE_OR_FIXED_AMOUNT
,      EE_CONT_BASE_METHOD
,      EE_FIXED_AMOUNT
,      ER_CONT_BASE_METHOD
,      ER_FIXED_AMOUNT
,      CONTRIBUTION_KEY
,      HEALTH_ORG_ID
,      PENSION_ORG_ID
,      UNEMPLOYMENT_ORG_ID
,      SPECIAL_CARE_ORG_ID
,      OCCUPATION_KEY
,      PEOPLE_GROUP_KEY
,      LEGAL_AREA_CODE
,      HEALTH_INSURANCE_NUMBER
,      PRIVATE_HEALTH_PROVIDER_ORG_ID
,      PRIVATE_HEALTH_CONTRIBUTION
,      VOLUNTARY_PENSION_PROV_ID
,      VOLUNTARY_PENSION_CONTR
,      CONTRIBUTION_TRANSFER_BY_CODE
,      SPECIAL_CARE_CONTRIBUTION
,      PRIVATELY_INSURED_FLAG
,      VOLUNTARY_PENSION_NUMBER
,      ADD_INSURANCE_PROVIDER
,      ADD_INS_MEMSHIP_NUMBER
,      ADD_INS_STATUS
,      ADD_INS_START_DATE
,      ADD_INS_END_DATE
,      ADD_INS_END_REASON
,      FORM_NUMBER
,      EXEMPTION_ISSUE_DATE
,      VALID_FROM
,      VALID_TO
,      TAX_FREE_RENUMERATION
,      TAX_CARD_NUMBER
,      TAX_YEAR
,      ISSUE_DATE
,      CARD_ISSUER
,      TAX_CARD_LOCATION
,      TAX_STATUS
,      TAX_TABLE
,      TAX_CLASS
,      NO_OF_CHILDREN
,      YEARLY_TAX_FREE_INCOME
,      MONTHLY_TAX_FREE_INCOME
,      ADDITIONAL_YEAR_TAXABLE_INCOME
,      YEARLY_INCOME_TAX_CALC_FLAG
,      CHAMBER_CONTRIBUTION
,      PENSIONERS_TAX_FLA
,      ADDITIONAL_MTH_TAXABLE_INCOME
,      EMPLOYEE_CHURCH_CODE
,      SPOUSE_CHURCH_CODE
,      BUNDESLAND_CHURCH
,      YEARLY_CHURCH_TAX_FLAG
,      MAX_CHURCH_TAX_FLAG
,      UPDATED
,      TAX_OFFICE_ORG_ID
,      ORIGINATING_CPAM_INFORMATION
,      ORIGINATING_ABSENCE
,      OVERTIME_SCHEME
,      BONIFICATION_METHOD
,      MAJORATION_METHOD
,      REGULARISATION_START_DATE
,      PENSION_CATEGORY
,      ARRCO_PROVIDER
,      ARRCO_IDENTIFICATION_NUMBER
,      AGIRC_PROVIDER
,      AGIRC_IDENTIFICATION_NUMBER
,      OPTIONAL_ACCESSORIES_FITTED
,      PRICE_OF_ACCESSORIES_ADDED_AFT
,      CAPITAL_CONTRIBUTIONS_MADE
,      PRIVATE_USE_PAYMENTS
,      ENGINE_CC_FOR_FUEL_CHARGE
,      MILEAGE_BAND
,      BENEFIT_CHARGE
,      AGE_DISCOUNT
,      TOTAL_DAYS_UNAVAILABLE
,      UNAVAILABLE_VALUE
,      FUEL_BENEFIT
,      BENEFIT_PERCENTAGE
,      STANDARD_DISCOUNT
,      ADDITIONAL_DISCOUNT
,      ACCESSORIES
,      ENGINE_CC
,      CAR_BENEFIT_FULL_YEAR
,      CAR_UNAVAILABLE_VALUE
,      STANDARD_DISCOUNT_PERCENTAGE
,      ADDITIONAL_DISCOUNT_PERCENTAGE
,      DATE_FREE_FUEL_WITHDRAWN
,      FREE_FUEL_REINSTATED
,      ADDITIONAL_WITHDRAWN_FUEL_DAYS
,      FUEL_BENEFIT_FULL_YEAR
,      FUEL_BENEFIT_UNAVAILABLE_VALUE
,      VALID_BENEFIT_END_DATE
,      OFFICIAL_RATE_OF_INTEREST
,      ANNUAL_INTEREST_VALUE
,      INTEREST_VALUE
,      CALCULATION_METHOD
,      UNAVAILABLE_DATE_FROM_C
,      UNAVAILABLE_DATE_TO_C
,      DAYS_UNAVAILABLE_C
,      UNAVAILABLE_DATE_FROM_D
,      UNAVAILABLE_DATE_TO_D
,      DAYS_UNAVAILABLE_D
,      SECTION_198_CLAIM_INDICATOR
,      NOTES
,      TOTAL_DAYS_NO_FUEL_BENEFIT
,      SHARED_VAN_FUEL_REDUCTION
,      P6_ISSUE_DATE
,      P6_MESSAGE_DATE
,      ADDRESS_ID
,      SCHEME_ID
,      INTEREST_CALC_FROM_DATE_1
,      INTEREST_CALC_TO_DATE_1
,      INTEREST_CALCULATION_BASE_1
,      INTEREST_RATE_1
,      INTEREST_CALC_FROM_DATE_2
,      INTEREST_CALC_TO_DATE_2
,      INTEREST_CALCULATION_BASE2
,      INTEREST_RATE_2
,      INTEREST_CALC_FROM_DATE_3
,      INTEREST_CALC_TO_DATE_3
,      INTEREST_CALCULATION_BASE_3
,      INTEREST_RATE_3
,      INTEREST_CALC_FROM_DATE_4
,      INTEREST_CALC_TO_DATE_4
,      INTEREST_CALCULATION_BASE_4
,      INTEREST_RATE_4
,      INTEREST_CALC_FROM_DATE_5
,      INTEREST_CALC_TO_DATE_5
,      INTEREST_CALCULATION_BASE_5
,      INTEREST_RATE_5
,      PREVIOUS_CASE_NUMBER
,      COURT_ORDER_ORIGIN
,      COMMENTS
,      REFERENCE_NUMBER
,      DEDUCTION_AUTHORITY
,      TOTAL_DEDUCTION_AMOUNT
,      START_DATE
,      END_DATE
,      PAYSLIP_INFORMATION
,      FIPS_CODE
,      MEDICAL_SUPPORT_INDICATOR
,      DOCUMENT_NUMBER
,      OVRRIDE_GARN_EX_DI_PCT
,      OVRRIDE_GARN_EX_DI_PCT_ARR
,      OVRRIDE_GARN_EX_DI_PCT_DEP
,      OVRRIDE_GARN_EX_DI_PCT_DEP_ARR
,      OVRD_GARN_MAX_WTHLDNG_DURATION
,      INITIAL_FEE_FLAG
,      EE_OR_SPOUSE_BLIND___AGE____65
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ELEMENT_ENTRIES_F_DFV;

Dependencies

[top of page]

APPS

FND_NUMBER - show dependent code

PAY_ELEMENT_ENTRIES_F

PUBLIC

PAY_ELEMENT_ENTRIES_F_DFV