[Home] [Help]
[Dependency Information]
| Object Name: | GHR_PA_REQUEST_EXTRA_INFO1_DFV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TYPE
, ASSIGNMENT_NTE_START_DATE
, ASSIGNMENT_NTE
, APPOINTMENT_TYPE
, DATE_ARRIVED_PERSONNEL_OFFICE
, DATE_LAST_EQUIVALENT_INCREASE
, DATE_WGI_DUE
, PROMOTION_ELIGIBILITY_DUE_DATE
, FERS_COVERAGE
, DISABILITY_CODE
, NON_DISCLOSURE_AGMT_STATUS
, PART_TIME_INDICATOR
, POSITION_WORKING_TITLE
, PREVIOUS_RETIREMENT_COVERAGE
, QUALIFICATION_STANDARDS_WAIVER
, RACE_OR_NATIONAL_ORIGIN
, TYPE_OF_EMPLOYMENT
, PAY_STATUS_USERRA_STATUS
, PATHWAYS_PROGRAM_START_DATE
, PATHWAYS_PROGRAM_EXTN_END_DATE
, PATHWAYS_PROGRAM_END_DATE
, AGENCY_CODE_TRANSFER_FROM
, AWARD_AGENCY_CODE
, AWARD_TYPE
, GROUP_AWARD_ID
, TANGIBLE_BENEFIT_DOLLARS
, DATE_AWARD_EARNED
, AWARD_APPROPRIATION_CODE
, DATE_EX_EMP_AWARD_PAID
, FEHB_ELIGIBILITY_EXPIRATION
, FEHB_TEMP_ELIGIBILITY_DATE
, FEHB_HEALTH_PLAN
, FEHB_ENROLLMENT
, FEHB_DEPENDENT_CERT_EXPIRE
, FEHB_TEMPS_TOTAL_COST
, FEHB_PRE_TAX_WAIVER
, FEGLI_ELIGIBILITY_EXPIRES
, FERS_ELIGIBILITY_EXPIRES
, TSP_AMOUNT
, TSP_RATE
, TSP_STATUS
, TSP_STATUS_DATE
, TSP_AGENCY_CONTRIB_ELIG_DATE
, TSP_EMP_CONTRIB_ELIG_DATE
, TSP_ROTH_401K_AMOUNT
, TSP_ROTH_401K_RATE
, FEGLI_INDICATOR
, FEGLI_ELECTION_DATE
, FEGLI_ELECTION_NOTF_DATE
, FEHB_INDICATOR
, FEHB_ELECTION_DATE
, FEHB_ELECTION_NOTF_DATE
, RETIREMENT_INDICATOR
, RETIREMENT_ELECTION_DATE
, RETIREMENT_ELECTION_NOTF_DATE
, CONT_TERM_INSUFF_PAY_ELEC_DATE
, CONT_TERM_INSUFF_PAY_NOTF_DATE
, CONT_TERM_INSUFF_PAY_PMT_CODE
, FEGLI_ASSIGNMENT_INDICATOR
, FEGLI_POST_ELEC_BASIC_INS_AMT
, FEGLI_COURT_ORDER_INDICATOR
, FEGLI_BENF_DESIGNTN_INDICATOR
, FEHB_EVENT_CODE
, PERSONNEL_OFFICE_ID
, AGENCY_SUBELEMENT_CODE
, DATE_PROB_TRIAL_PERIOD_BEGINS
, DATE_PROB_TRIAL_PERIOD_ENDS
, DATE_WGI_POSTPONE_EFFECTIVE
, CREDITABLE_MILITARY_SERVICE
, FROZEN_SERVICE
, SCD_TSP
, DATE_CONVERSION_CAREER_BEGINS
, DATE_CONVERSION_CAREER_DUE
, DATE_RECMD_CONVERSION_BEGINS
, DATE_RECMD_CONVERSION_DUE
, DATE_VRA_CONVERSION_DUE
, LAST_ACTION_CODE
, LOCATION
, DETAIL_TYPE
, UNCLASSIFIED_DUTIES_INDICATOR
, POSITION_NAME
, VALID_GRADE
, OCCUPATIONAL_SERIES
, APPROPRIATION_CODE
, FLSA_CATEGORY
, BARGAINING_UNIT_STATUS
, WORK_SCHEDULE
, DUTY_LOCATION
, ORGANIZATION
, PREMIUM_PAY_IND
, EDP_TYPE
, KEY_EMERGENCY_ESSENTIAL_EMPL
, CODE
, AMOUNT_OR_PERCENT
, HISPANIC
, AMERICAN_INDIAN_OR_ALASKAN_NAT
, ASIAN
, BLACK_OR_AFRICAN_AMERICAN
, NATIVE_HAWAIIAN_OR_OTHER_PACIF
, WHITE
, ELIGIBILITY_EXPIRATION
, FEGLI_CHANGE_LIFE_EVENT
, CERTIFICATION_DATE
, PAY_LEVEL_OR_RATE
, NUMBER_FAMILY_MEMBERS
, MISCELLANEOUS_EXPENSE
, WARDROBE_EXPENSE
, PRE_DEPARTURE_SUBS_EXPENSE
, LEASE_PENALTY_EXPENSE
, TOTAL_AUTHORIZED_AMOUNT
, AGENCY_USE_BLOCK_25
, AGENCY_DATA_BLOCK_40
, AGENCY_DATA_BLOCK_41
, AGENCY_DATA_BLOCK_42
, AGENCY_DATA_BLOCK_43
, AGENCY_DATA_BLOCK_44
, HAZARD_TYPE
, AMOUNT
, PURCHASE_AMOUNT
, PURCHASE_DATE
, RENT_AMOUNT
, UTILITY_AMOUNT
, QUARTERS_TYPE
, SHARED_PERCENT
, NUM_FAMILY_MEMBERS
, SUMMER_RECORD_IND
, QUARTERS_GROUP
, CURRENCY
, AGENCY_CODE_TRANSFER_TO
, FULL_TIME_STATUS
, LENGTH_OF_SERVICE
, SCARCE_SPECIALTY
, SPECIALTY_OR_BOARD_CERT
, GEOGRAPHIC_LOCATION
, EXCEPTIONAL_QUALIFICATIONS
, EXECUTIVE_POSITION
, DENTIST_POST_GRADUATE_TRAINING
, MD_DDS_TOTAL_SPECIAL_PAY
, MD_DDS_SPECIAL_PAY_NTE_DATE
, AWARDS_CASE_NUMBER
, STORED_ACCOUNTING_INDICATOR
, CASH_AWARD_TYPE_CODE
, FIRST_YEAR_SAVINGS
, CASH_AWARD_PAY_CODE
, NUMBER_OF_PERSONS_CASH_AWARD
, ACCOUNTING_DISTRIBUTION_FISCAL
, ACCOUNTING_DISTRIBUTION_APPROP
, ACCOUNTING_DISTRIBUTION_SUB
, CASH_AWARD_ACCOUNTING
, CASH_AWARD_CODE
, AUTHENTICATION_DATE
, SURVIVOR_ELECTION
, MILITARY_DEPOSIT
, PART_TIME_SERVICE
, ADMINISTRATIVE_FEE
, DISABILITY_RETIREMENT_APP
, ADVERSE_ACTION_NOAC
, CAUSE_OF_DISCIPLINARY_ACTION
, DATE_OF_ADVERSE_ACTION
, DAYS_SUSPENDED
, DATE_SUSPENSION_OVER_30_DAYS
, DATE_SUSPENSION_UNDER_30_DAYS
, PIP_ACTION_TAKEN
, PIP_BEGINING_DATE
, PIP_ENDING_DATE
, PIP_EXTENSIONS
, PIP_LENGTH
, PAYROLL_TYPE
, RATING_OF_RECORD
, RATING_OF_RECORD_PATTERN
, RATING_OF_RECORD_LEVEL
, DATE_APPRAISAL_PERIOD_STARTS
, DATE_APPRAISAL_PERIOD_ENDS
, APPRAISAL_TYPE
, DATE_INITIAL_APPRAISAL_DUE
, DATE_EFFECTIVE
, UNIT
, ORGANIZATION_STRUCTURE_ID
, OFFICE_SYMBOL
, PAY_PLAN
, GRADE
, DATE_DUE
, APPRAISAL_SYSTEM_IDENTIFIER
, OPTIONAL_INFORMATION
, PERFORMANCE_RATING_POINTS
, DATE_FROM
, DATE_TO
, RETAINED_GRADE
, RETAINED_STEP_OR_RATE
, RETAINED_PAY_PLAN
, RETAINED_PAY_TABLE_ID
, RETAINED_LOCALITY_PERCENT
, RETAINED_PAY_BASIS
, PERCENTAGE
, PAYROLL_OFFICE_ID
, ORGANIZATION_FUNCTION_CODE
, POSITION_S_ORGANIZATION
, TARGET_ORGANIZATION_NAME
, OPM_ORGANIZATIONAL_COMPONENT
, DATE_RECRUITMENT_AGMT_EXPIRES
, DATE_RELOCATION_AGMT_EXPIRES
, RETENTION_INCENTIVE_REVIEW_DT
, SUM
, ELIGIBILITY_EXPIRES
, SPECIAL_POPULATION_CODE
, CSRS_EXCLUDED_APPTS
, FERS_COVERAGE_EXCLUDED_APPTS
, FICA_COVERAGE_INDICATOR_1
, FICA_COVERAGE_INDICATOR_2
, RETENTION_ALLOW_REVIEW_DATE
, TEMPORARY_PROMOTION_STEP
, SCD_CIVILIAN
, SCD_RETIREMENT
, SCD_RIF
, SCD_SES
, SCD_SPECIAL_RETIREMENT
, CREDITABLE_SERVICE_FOR_ANNUAL
, SCD_LENGTH_OF_SERVICE
, ALLOWANCE_AMOUNT
, CATEGORY
, SERVICE_OBLIGATION_TYPE_CODE
, SERVICE_OBLIGATION_START_DATE
, SERVICE_OBLIGATION_END_DATE
, SEVERANCE_AMOUNT
, TOTAL_ENTITLEMENT_WEEKS
, NUMBER_WEEKS_PAID
, WEEKLY_AMOUNT
, REPAYMENT_SCHEDULE
, REVIEW_DATE
, EXTRA_INFO_ID
, RETAINED_GRADE1
, TERMINATE
, RETAINED_LOCALITY_PERCENTAGE
, ORIGINAL_RPA
, ALLOWANCE_TYPE
, DAILY_RATE
, REASON_FOR_SUBMISSION
, EXPLANATION
, SERVICE
, AGENCY_USE
, CURRENT_APPOINTMENT_AUTH_1
, CURRENT_APPOINTMENT_DESC__1_
, CURRENT_APPOINTMENT_AUTH_2
, CURRENT_APPOINTMENT_DESC__2_
, CONCATENATED_SEGMENTS
FROM APPS.GHR_PA_REQUEST_EXTRA_INFO1_DFV;
APPS
FND_NUMBER
- show dependent code
GHR_PA_REQUEST_EXTRA_INFO
APPS.GHR_PA_REQUEST_EXTRA_INFO1_DFV is not referenced by any database object
|
|
|
|