DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.GHR_PA_REQUEST_EXTRA_INFO1_DFV

Object Details
Object Name: GHR_PA_REQUEST_EXTRA_INFO1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TYPE VARCHAR2 (30)
ASSIGNMENT_NTE_START_DATE DATE

ASSIGNMENT_NTE DATE

APPOINTMENT_TYPE VARCHAR2 (150)
DATE_ARRIVED_PERSONNEL_OFFICE DATE

DATE_LAST_EQUIVALENT_INCREASE DATE

DATE_WGI_DUE DATE

PROMOTION_ELIGIBILITY_DUE_DATE DATE

FERS_COVERAGE VARCHAR2 (150)
DISABILITY_CODE VARCHAR2 (150)
NON_DISCLOSURE_AGMT_STATUS VARCHAR2 (150)
PART_TIME_INDICATOR VARCHAR2 (150)
POSITION_WORKING_TITLE VARCHAR2 (150)
PREVIOUS_RETIREMENT_COVERAGE VARCHAR2 (150)
QUALIFICATION_STANDARDS_WAIVER VARCHAR2 (150)
RACE_OR_NATIONAL_ORIGIN VARCHAR2 (150)
TYPE_OF_EMPLOYMENT VARCHAR2 (150)
PAY_STATUS_USERRA_STATUS VARCHAR2 (150)
PATHWAYS_PROGRAM_START_DATE DATE

PATHWAYS_PROGRAM_EXTN_END_DATE DATE

PATHWAYS_PROGRAM_END_DATE DATE

AGENCY_CODE_TRANSFER_FROM VARCHAR2 (150)
AWARD_AGENCY_CODE VARCHAR2 (150)
AWARD_TYPE VARCHAR2 (150)
GROUP_AWARD_ID NUMBER

TANGIBLE_BENEFIT_DOLLARS VARCHAR2 (150)
DATE_AWARD_EARNED DATE

AWARD_APPROPRIATION_CODE VARCHAR2 (150)
DATE_EX_EMP_AWARD_PAID DATE

FEHB_ELIGIBILITY_EXPIRATION DATE

FEHB_TEMP_ELIGIBILITY_DATE DATE

FEHB_HEALTH_PLAN VARCHAR2 (150)
FEHB_ENROLLMENT VARCHAR2 (150)
FEHB_DEPENDENT_CERT_EXPIRE DATE

FEHB_TEMPS_TOTAL_COST VARCHAR2 (150)
FEHB_PRE_TAX_WAIVER VARCHAR2 (150)
FEGLI_ELIGIBILITY_EXPIRES DATE

FERS_ELIGIBILITY_EXPIRES DATE

TSP_AMOUNT NUMBER

TSP_RATE NUMBER

TSP_STATUS VARCHAR2 (150)
TSP_STATUS_DATE DATE

TSP_AGENCY_CONTRIB_ELIG_DATE DATE

TSP_EMP_CONTRIB_ELIG_DATE DATE

TSP_ROTH_401K_AMOUNT NUMBER

TSP_ROTH_401K_RATE NUMBER

FEGLI_INDICATOR VARCHAR2 (150)
FEGLI_ELECTION_DATE DATE

FEGLI_ELECTION_NOTF_DATE DATE

FEHB_INDICATOR VARCHAR2 (150)
FEHB_ELECTION_DATE DATE

FEHB_ELECTION_NOTF_DATE DATE

RETIREMENT_INDICATOR VARCHAR2 (150)
RETIREMENT_ELECTION_DATE DATE

RETIREMENT_ELECTION_NOTF_DATE DATE

CONT_TERM_INSUFF_PAY_ELEC_DATE DATE

CONT_TERM_INSUFF_PAY_NOTF_DATE DATE

CONT_TERM_INSUFF_PAY_PMT_CODE VARCHAR2 (150)
FEGLI_ASSIGNMENT_INDICATOR VARCHAR2 (150)
FEGLI_POST_ELEC_BASIC_INS_AMT NUMBER

FEGLI_COURT_ORDER_INDICATOR VARCHAR2 (150)
FEGLI_BENF_DESIGNTN_INDICATOR VARCHAR2 (150)
FEHB_EVENT_CODE VARCHAR2 (150)
PERSONNEL_OFFICE_ID VARCHAR2 (150)
AGENCY_SUBELEMENT_CODE VARCHAR2 (150)
DATE_PROB_TRIAL_PERIOD_BEGINS DATE

DATE_PROB_TRIAL_PERIOD_ENDS DATE

DATE_WGI_POSTPONE_EFFECTIVE DATE

CREDITABLE_MILITARY_SERVICE VARCHAR2 (150)
FROZEN_SERVICE VARCHAR2 (150)
SCD_TSP DATE

DATE_CONVERSION_CAREER_BEGINS DATE

DATE_CONVERSION_CAREER_DUE DATE

DATE_RECMD_CONVERSION_BEGINS DATE

DATE_RECMD_CONVERSION_DUE DATE

DATE_VRA_CONVERSION_DUE DATE

LAST_ACTION_CODE VARCHAR2 (150)
LOCATION VARCHAR2 (150)
DETAIL_TYPE VARCHAR2 (150)
UNCLASSIFIED_DUTIES_INDICATOR VARCHAR2 (150)
POSITION_NAME VARCHAR2 (150)
VALID_GRADE VARCHAR2 (150)
OCCUPATIONAL_SERIES VARCHAR2 (150)
APPROPRIATION_CODE VARCHAR2 (150)
FLSA_CATEGORY VARCHAR2 (150)
BARGAINING_UNIT_STATUS VARCHAR2 (150)
WORK_SCHEDULE VARCHAR2 (150)
DUTY_LOCATION VARCHAR2 (150)
ORGANIZATION VARCHAR2 (150)
PREMIUM_PAY_IND VARCHAR2 (150)
EDP_TYPE VARCHAR2 (150)
KEY_EMERGENCY_ESSENTIAL_EMPL VARCHAR2 (150)
CODE VARCHAR2 (150)
AMOUNT_OR_PERCENT NUMBER

HISPANIC VARCHAR2 (150)
AMERICAN_INDIAN_OR_ALASKAN_NAT VARCHAR2 (150)
ASIAN VARCHAR2 (150)
BLACK_OR_AFRICAN_AMERICAN VARCHAR2 (150)
NATIVE_HAWAIIAN_OR_OTHER_PACIF VARCHAR2 (150)
WHITE VARCHAR2 (150)
ELIGIBILITY_EXPIRATION DATE

FEGLI_CHANGE_LIFE_EVENT VARCHAR2 (150)
CERTIFICATION_DATE DATE

PAY_LEVEL_OR_RATE VARCHAR2 (150)
NUMBER_FAMILY_MEMBERS NUMBER

MISCELLANEOUS_EXPENSE NUMBER

WARDROBE_EXPENSE NUMBER

PRE_DEPARTURE_SUBS_EXPENSE NUMBER

LEASE_PENALTY_EXPENSE NUMBER

TOTAL_AUTHORIZED_AMOUNT VARCHAR2 (150)
AGENCY_USE_BLOCK_25 VARCHAR2 (150)
AGENCY_DATA_BLOCK_40 VARCHAR2 (150)
AGENCY_DATA_BLOCK_41 VARCHAR2 (150)
AGENCY_DATA_BLOCK_42 VARCHAR2 (150)
AGENCY_DATA_BLOCK_43 VARCHAR2 (150)
AGENCY_DATA_BLOCK_44 VARCHAR2 (150)
HAZARD_TYPE VARCHAR2 (150)
AMOUNT NUMBER

PURCHASE_AMOUNT NUMBER

PURCHASE_DATE DATE

RENT_AMOUNT NUMBER

UTILITY_AMOUNT NUMBER

QUARTERS_TYPE VARCHAR2 (150)
SHARED_PERCENT NUMBER

NUM_FAMILY_MEMBERS NUMBER

SUMMER_RECORD_IND VARCHAR2 (150)
QUARTERS_GROUP VARCHAR2 (150)
CURRENCY VARCHAR2 (150)
AGENCY_CODE_TRANSFER_TO VARCHAR2 (150)
FULL_TIME_STATUS NUMBER

LENGTH_OF_SERVICE NUMBER

SCARCE_SPECIALTY NUMBER

SPECIALTY_OR_BOARD_CERT NUMBER

GEOGRAPHIC_LOCATION NUMBER

EXCEPTIONAL_QUALIFICATIONS NUMBER

EXECUTIVE_POSITION NUMBER

DENTIST_POST_GRADUATE_TRAINING NUMBER

MD_DDS_TOTAL_SPECIAL_PAY NUMBER

MD_DDS_SPECIAL_PAY_NTE_DATE DATE

AWARDS_CASE_NUMBER VARCHAR2 (150)
STORED_ACCOUNTING_INDICATOR VARCHAR2 (150)
CASH_AWARD_TYPE_CODE VARCHAR2 (150)
FIRST_YEAR_SAVINGS NUMBER

CASH_AWARD_PAY_CODE VARCHAR2 (150)
NUMBER_OF_PERSONS_CASH_AWARD VARCHAR2 (150)
ACCOUNTING_DISTRIBUTION_FISCAL VARCHAR2 (150)
ACCOUNTING_DISTRIBUTION_APPROP VARCHAR2 (150)
ACCOUNTING_DISTRIBUTION_SUB VARCHAR2 (150)
CASH_AWARD_ACCOUNTING VARCHAR2 (150)
CASH_AWARD_CODE VARCHAR2 (150)
AUTHENTICATION_DATE DATE

SURVIVOR_ELECTION VARCHAR2 (150)
MILITARY_DEPOSIT VARCHAR2 (150)
PART_TIME_SERVICE VARCHAR2 (150)
ADMINISTRATIVE_FEE VARCHAR2 (150)
DISABILITY_RETIREMENT_APP VARCHAR2 (150)
ADVERSE_ACTION_NOAC VARCHAR2 (150)
CAUSE_OF_DISCIPLINARY_ACTION VARCHAR2 (150)
DATE_OF_ADVERSE_ACTION DATE

DAYS_SUSPENDED VARCHAR2 (150)
DATE_SUSPENSION_OVER_30_DAYS DATE

DATE_SUSPENSION_UNDER_30_DAYS DATE

PIP_ACTION_TAKEN VARCHAR2 (150)
PIP_BEGINING_DATE DATE

PIP_ENDING_DATE DATE

PIP_EXTENSIONS VARCHAR2 (150)
PIP_LENGTH VARCHAR2 (150)
PAYROLL_TYPE VARCHAR2 (150)
RATING_OF_RECORD VARCHAR2 (150)
RATING_OF_RECORD_PATTERN VARCHAR2 (150)
RATING_OF_RECORD_LEVEL VARCHAR2 (150)
DATE_APPRAISAL_PERIOD_STARTS DATE

DATE_APPRAISAL_PERIOD_ENDS DATE

APPRAISAL_TYPE VARCHAR2 (150)
DATE_INITIAL_APPRAISAL_DUE DATE

DATE_EFFECTIVE DATE

UNIT VARCHAR2 (150)
ORGANIZATION_STRUCTURE_ID VARCHAR2 (150)
OFFICE_SYMBOL VARCHAR2 (150)
PAY_PLAN VARCHAR2 (150)
GRADE VARCHAR2 (150)
DATE_DUE DATE

APPRAISAL_SYSTEM_IDENTIFIER VARCHAR2 (150)
OPTIONAL_INFORMATION VARCHAR2 (150)
PERFORMANCE_RATING_POINTS NUMBER

DATE_FROM DATE

DATE_TO DATE

RETAINED_GRADE VARCHAR2 (150)
RETAINED_STEP_OR_RATE VARCHAR2 (150)
RETAINED_PAY_PLAN VARCHAR2 (150)
RETAINED_PAY_TABLE_ID VARCHAR2 (150)
RETAINED_LOCALITY_PERCENT NUMBER

RETAINED_PAY_BASIS VARCHAR2 (150)
PERCENTAGE NUMBER

PAYROLL_OFFICE_ID VARCHAR2 (150)
ORGANIZATION_FUNCTION_CODE VARCHAR2 (150)
POSITION_S_ORGANIZATION VARCHAR2 (150)
TARGET_ORGANIZATION_NAME VARCHAR2 (150)
OPM_ORGANIZATIONAL_COMPONENT VARCHAR2 (150)
DATE_RECRUITMENT_AGMT_EXPIRES DATE

DATE_RELOCATION_AGMT_EXPIRES DATE

RETENTION_INCENTIVE_REVIEW_DT DATE

SUM NUMBER

ELIGIBILITY_EXPIRES DATE

SPECIAL_POPULATION_CODE VARCHAR2 (150)
CSRS_EXCLUDED_APPTS VARCHAR2 (150)
FERS_COVERAGE_EXCLUDED_APPTS VARCHAR2 (150)
FICA_COVERAGE_INDICATOR_1 VARCHAR2 (150)
FICA_COVERAGE_INDICATOR_2 VARCHAR2 (150)
RETENTION_ALLOW_REVIEW_DATE DATE

TEMPORARY_PROMOTION_STEP VARCHAR2 (150)
SCD_CIVILIAN DATE

SCD_RETIREMENT DATE

SCD_RIF DATE

SCD_SES DATE

SCD_SPECIAL_RETIREMENT DATE

CREDITABLE_SERVICE_FOR_ANNUAL VARCHAR2 (150)
SCD_LENGTH_OF_SERVICE DATE

ALLOWANCE_AMOUNT NUMBER

CATEGORY VARCHAR2 (150)
SERVICE_OBLIGATION_TYPE_CODE VARCHAR2 (150)
SERVICE_OBLIGATION_START_DATE DATE

SERVICE_OBLIGATION_END_DATE DATE

SEVERANCE_AMOUNT NUMBER

TOTAL_ENTITLEMENT_WEEKS NUMBER

NUMBER_WEEKS_PAID NUMBER

WEEKLY_AMOUNT NUMBER

REPAYMENT_SCHEDULE VARCHAR2 (150)
REVIEW_DATE DATE

EXTRA_INFO_ID VARCHAR2 (150)
RETAINED_GRADE1 VARCHAR2 (150)
TERMINATE VARCHAR2 (150)
RETAINED_LOCALITY_PERCENTAGE NUMBER

ORIGINAL_RPA VARCHAR2 (150)
ALLOWANCE_TYPE VARCHAR2 (150)
DAILY_RATE NUMBER

REASON_FOR_SUBMISSION VARCHAR2 (150)
EXPLANATION VARCHAR2 (150)
SERVICE VARCHAR2 (150)
AGENCY_USE VARCHAR2 (150)
CURRENT_APPOINTMENT_AUTH_1 VARCHAR2 (150)
CURRENT_APPOINTMENT_DESC__1_ VARCHAR2 (150)
CURRENT_APPOINTMENT_AUTH_2 VARCHAR2 (150)
CURRENT_APPOINTMENT_DESC__2_ VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (3201)
Query Text

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;

Dependencies

[top of page]

APPS.GHR_PA_REQUEST_EXTRA_INFO1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymGHR_PA_REQUEST_EXTRA_INFO

APPS.GHR_PA_REQUEST_EXTRA_INFO1_DFV is not referenced by any database object