Skip to content

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

VIEW: HR.GHR_PA_REQUESTS#

Object Details
Object Name: GHR_PA_REQUESTS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PA_REQUEST_ID NUMBER (15) Yes
PA_NOTIFICATION_ID NUMBER (22)
NOA_FAMILY_CODE VARCHAR2 (30) Yes
ROUTING_GROUP_ID NUMBER (15)
ACADEMIC_DISCIPLINE VARCHAR2 (30)
ADDITIONAL_INFO_PERSON_ID NUMBER (10)
ADDITIONAL_INFO_TEL_NUMBER VARCHAR2 (60)
AGENCY_CODE VARCHAR2 (30)
ALTERED_PA_REQUEST_ID NUMBER (15)
ANNUITANT_INDICATOR VARCHAR2 (30)
ANNUITANT_INDICATOR_DESC VARCHAR2 (80)
APPROPRIATION_CODE1 VARCHAR2 (30)
APPROPRIATION_CODE2 VARCHAR2 (30)
APPROVAL_DATE DATE

APPROVING_OFFICIAL_FULL_NAME VARCHAR2 (240)
APPROVING_OFFICIAL_WORK_TITLE VARCHAR2 (60)
AUTHORIZED_BY_PERSON_ID NUMBER (10)
AUTHORIZED_BY_TITLE VARCHAR2 (240)
AWARD_AMOUNT NUMBER (15)
AWARD_PERCENTAGE NUMBER (5)
AWARD_UOM VARCHAR2 (30)
BARGAINING_UNIT_STATUS VARCHAR2 (30)
CITIZENSHIP VARCHAR2 (30)
CONCURRENCE_DATE DATE

CUSTOM_PAY_CALC_FLAG VARCHAR2 (1)
DUTY_STATION_CODE VARCHAR2 (9)
DUTY_STATION_DESC VARCHAR2 (150)
DUTY_STATION_ID NUMBER (15)
DUTY_STATION_LOCATION_ID NUMBER (15)
EDUCATION_LEVEL VARCHAR2 (30)
EFFECTIVE_DATE DATE

EMPLOYEE_ASSIGNMENT_ID NUMBER (15)
EMPLOYEE_DATE_OF_BIRTH DATE

EMPLOYEE_DEPT_OR_AGENCY VARCHAR2 (80)
EMPLOYEE_FIRST_NAME VARCHAR2 (150)
EMPLOYEE_LAST_NAME VARCHAR2 (150)
EMPLOYEE_MIDDLE_NAMES VARCHAR2 (60)
EMPLOYEE_NATIONAL_IDENTIFIER VARCHAR2 (30)
FEGLI VARCHAR2 (30)
FEGLI_DESC VARCHAR2 (80)
FIRST_ACTION_LA_CODE1 VARCHAR2 (30)
FIRST_ACTION_LA_CODE2 VARCHAR2 (30)
FIRST_ACTION_LA_DESC1 VARCHAR2 (240)
FIRST_ACTION_LA_DESC2 VARCHAR2 (240)
FIRST_NOA_CANCEL_OR_CORRECT VARCHAR2 (10)
FIRST_NOA_CANC_PA_REQUEST_ID NUMBER (15)
FIRST_NOA_CODE VARCHAR2 (4)
FIRST_NOA_DESC VARCHAR2 (240)
FIRST_NOA_ID NUMBER (15)
FIRST_NOA_PA_REQUEST_ID NUMBER (15)
FLSA_CATEGORY VARCHAR2 (30)
FORWARDING_ADDRESS_LINE1 VARCHAR2 (240)
FORWARDING_ADDRESS_LINE2 VARCHAR2 (240)
FORWARDING_ADDRESS_LINE3 VARCHAR2 (240)
FORWARDING_COUNTRY VARCHAR2 (60)
FORWARDING_COUNTRY_SHORT_NAME VARCHAR2 (80)
FORWARDING_POSTAL_CODE VARCHAR2 (30)
FORWARDING_REGION_2 VARCHAR2 (120)
FORWARDING_TOWN_OR_CITY VARCHAR2 (30)
FROM_ADJ_BASIC_PAY NUMBER (15)
FROM_AGENCY_CODE VARCHAR2 (30)
FROM_AGENCY_DESC VARCHAR2 (80)
FROM_BASIC_PAY NUMBER (15)
FROM_GRADE_OR_LEVEL VARCHAR2 (30)
FROM_LOCALITY_ADJ NUMBER (15)
FROM_OCC_CODE VARCHAR2 (150)
FROM_OFFICE_SYMBOL VARCHAR2 (30)
FROM_OTHER_PAY_AMOUNT NUMBER (15)
FROM_PAY_BASIS VARCHAR2 (30)
FROM_PAY_PLAN VARCHAR2 (2)
FROM_POSITION_ID NUMBER (15)
FROM_POSITION_ORG_LINE1 VARCHAR2 (40)
FROM_POSITION_ORG_LINE2 VARCHAR2 (40)
FROM_POSITION_ORG_LINE3 VARCHAR2 (40)
FROM_POSITION_ORG_LINE4 VARCHAR2 (40)
FROM_POSITION_ORG_LINE5 VARCHAR2 (40)
FROM_POSITION_ORG_LINE6 VARCHAR2 (40)
FROM_POSITION_NUMBER VARCHAR2 (15)
FROM_POSITION_SEQ_NO NUMBER (15)
FROM_POSITION_TITLE VARCHAR2 (240)
FROM_STEP_OR_RATE VARCHAR2 (30)
FROM_TOTAL_SALARY NUMBER (15)
FUNCTIONAL_CLASS VARCHAR2 (30)
NOTEPAD VARCHAR2 (2000)
NOTIFICATION_PRINTED_BY NUMBER (15)
NO_OF_NOTIFICATION_PRINTED NUMBER (5)
PART_TIME_HOURS NUMBER (5)
PAY_RATE_DETERMINANT VARCHAR2 (30)
PERSONNEL_OFFICE_ID VARCHAR2 (4)
PERSON_ID NUMBER (10)
POSITION_OCCUPIED VARCHAR2 (30)
PROPOSED_EFFECTIVE_ASAP_FLAG VARCHAR2 (1) Yes
PROPOSED_EFFECTIVE_DATE DATE

REQUESTED_BY_PERSON_ID NUMBER (10)
REQUESTED_BY_TITLE VARCHAR2 (240)
REQUESTED_DATE DATE

REQUESTING_OFFICE_REMARKS_DESC VARCHAR2 (2000)
REQUESTING_OFFICE_REMARKS_FLAG VARCHAR2 (1)
REQUEST_NUMBER VARCHAR2 (25)
RESIGN_AND_RETIRE_REASON_DESC VARCHAR2 (2000)
RETIREMENT_PLAN VARCHAR2 (30)
RETIREMENT_PLAN_DESC VARCHAR2 (80)
SECOND_ACTION_LA_CODE1 VARCHAR2 (30)
SECOND_ACTION_LA_CODE2 VARCHAR2 (30)
SECOND_ACTION_LA_DESC1 VARCHAR2 (240)
SECOND_ACTION_LA_DESC2 VARCHAR2 (240)
SECOND_NOA_CANCEL_OR_CORRECT VARCHAR2 (10)
SECOND_NOA_CANC_PA_REQUEST_ID NUMBER (15)
SECOND_NOA_CODE VARCHAR2 (30)
SECOND_NOA_DESC VARCHAR2 (240)
SECOND_NOA_ID NUMBER (15)
SECOND_NOA_PA_REQUEST_ID NUMBER (15)
SERVICE_COMP_DATE DATE

SF50_APPROVAL_DATE DATE

SF50_APPROVING_OFCL_FULL_NAME VARCHAR2 (240)
SF50_APPROVING_OFCL_WORK_TITLE VARCHAR2 (60)
STATUS VARCHAR2 (30)
SUPERVISORY_STATUS VARCHAR2 (30)
TENURE VARCHAR2 (30)
TO_ADJ_BASIC_PAY NUMBER (15)
TO_AP_PREMIUM_PAY_INDICATOR VARCHAR2 (30)
TO_AUO_PREMIUM_PAY_INDICATOR VARCHAR2 (30)
TO_AU_OVERTIME NUMBER (15)
TO_AVAILABILITY_PAY NUMBER (15)
TO_BASIC_PAY NUMBER (15)
TO_GRADE_ID NUMBER (15)
TO_GRADE_OR_LEVEL VARCHAR2 (30)
TO_JOB_ID NUMBER (15)
TO_LOCALITY_ADJ NUMBER (15)
TO_OCC_CODE VARCHAR2 (30)
TO_OFFICE_SYMBOL VARCHAR2 (30)
TO_ORGANIZATION_ID NUMBER (15)
TO_OTHER_PAY_AMOUNT NUMBER (15)
TO_PAY_BASIS VARCHAR2 (30)
TO_PAY_PLAN VARCHAR2 (2)
TO_POSITION_ID NUMBER (15)
TO_POSITION_ORG_LINE1 VARCHAR2 (40)
TO_POSITION_ORG_LINE2 VARCHAR2 (40)
TO_POSITION_ORG_LINE3 VARCHAR2 (40)
TO_POSITION_ORG_LINE4 VARCHAR2 (40)
TO_POSITION_ORG_LINE5 VARCHAR2 (40)
TO_POSITION_ORG_LINE6 VARCHAR2 (40)
TO_POSITION_NUMBER VARCHAR2 (15)
TO_POSITION_SEQ_NO NUMBER (15)
TO_POSITION_TITLE VARCHAR2 (240)
TO_RETENTION_ALLOWANCE NUMBER (15)
TO_RETENTION_ALLOW_PERCENTAGE NUMBER (5)
TO_STAFFING_DIFFERENTIAL NUMBER (15)
TO_STAFFING_DIFF_PERCENTAGE NUMBER (5)
TO_STEP_OR_RATE VARCHAR2 (30)
TO_SUPERVISORY_DIFFERENTIAL NUMBER (15)
TO_SUPERVISORY_DIFF_PERCENTAGE NUMBER (5)
TO_TOTAL_SALARY NUMBER (15)
VETERANS_PREFERENCE VARCHAR2 (30)
VETERANS_PREF_FOR_RIF VARCHAR2 (30)
VETERANS_STATUS VARCHAR2 (30)
WORK_SCHEDULE VARCHAR2 (30)
WORK_SCHEDULE_DESC VARCHAR2 (80)
YEAR_DEGREE_ATTAINED NUMBER (4)
FIRST_NOA_INFORMATION_CAT VARCHAR2 (30)
FIRST_NOA_INFORMATION1 VARCHAR2 (240)
FIRST_NOA_INFORMATION2 VARCHAR2 (150)
FIRST_NOA_INFORMATION3 VARCHAR2 (150)
FIRST_NOA_INFORMATION4 VARCHAR2 (150)
FIRST_NOA_INFORMATION5 VARCHAR2 (150)
SECOND_LAC1_INFORMATION_CAT VARCHAR2 (30)
SECOND_LAC1_INFORMATION1 VARCHAR2 (240)
SECOND_LAC1_INFORMATION2 VARCHAR2 (150)
SECOND_LAC1_INFORMATION3 VARCHAR2 (150)
SECOND_LAC1_INFORMATION4 VARCHAR2 (150)
SECOND_LAC1_INFORMATION5 VARCHAR2 (150)
SECOND_LAC2_INFORMATION_CAT VARCHAR2 (30)
SECOND_LAC2_INFORMATION1 VARCHAR2 (240)
SECOND_LAC2_INFORMATION2 VARCHAR2 (150)
SECOND_LAC2_INFORMATION3 VARCHAR2 (150)
SECOND_LAC2_INFORMATION4 VARCHAR2 (150)
SECOND_LAC2_INFORMATION5 VARCHAR2 (150)
SECOND_NOA_INFORMATION_CAT VARCHAR2 (30)
SECOND_NOA_INFORMATION1 VARCHAR2 (240)
SECOND_NOA_INFORMATION2 VARCHAR2 (150)
SECOND_NOA_INFORMATION3 VARCHAR2 (150)
SECOND_NOA_INFORMATION4 VARCHAR2 (150)
SECOND_NOA_INFORMATION5 VARCHAR2 (150)
FIRST_LAC1_INFORMATION_CAT VARCHAR2 (30)
FIRST_LAC1_INFORMATION1 VARCHAR2 (240)
FIRST_LAC1_INFORMATION2 VARCHAR2 (150)
FIRST_LAC1_INFORMATION3 VARCHAR2 (150)
FIRST_LAC1_INFORMATION4 VARCHAR2 (150)
FIRST_LAC1_INFORMATION5 VARCHAR2 (150)
FIRST_LAC2_INFORMATION_CAT VARCHAR2 (30)
FIRST_LAC2_INFORMATION1 VARCHAR2 (240)
FIRST_LAC2_INFORMATION2 VARCHAR2 (150)
FIRST_LAC2_INFORMATION3 VARCHAR2 (150)
FIRST_LAC2_INFORMATION4 VARCHAR2 (150)
FIRST_LAC2_INFORMATION5 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9) Yes
RPA_TYPE VARCHAR2 (30)
MASS_ACTION_ID NUMBER (15)
MASS_ACTION_ELIGIBLE_FLAG VARCHAR2 (1)
MASS_ACTION_SELECT_FLAG VARCHAR2 (1)
MASS_ACTION_COMMENTS VARCHAR2 (255)
AWARD_SALARY NUMBER (15)
PA_INCENTIVE_PAYMENT_OPTION VARCHAR2 (1)
INPUT_PAY_RATE_DETERMINANT VARCHAR2 (30)
FROM_PAY_TABLE_IDENTIFIER NUMBER (9)
TO_PAY_TABLE_IDENTIFIER NUMBER (9)
AUTHORIZED_BY_FULL_NAME VARCHAR2 (240)
REQUESTED_BY_FULL_NAME VARCHAR2 (240)
Query Text

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


SELECT PA_REQUEST_ID
,      PA_NOTIFICATION_ID
,      NOA_FAMILY_CODE
,      ROUTING_GROUP_ID
,      ACADEMIC_DISCIPLINE
,      ADDITIONAL_INFO_PERSON_ID
,      ADDITIONAL_INFO_TEL_NUMBER
,      AGENCY_CODE
,      ALTERED_PA_REQUEST_ID
,      ANNUITANT_INDICATOR
,      ANNUITANT_INDICATOR_DESC
,      APPROPRIATION_CODE1
,      APPROPRIATION_CODE2
,      APPROVAL_DATE
,      APPROVING_OFFICIAL_FULL_NAME
,      APPROVING_OFFICIAL_WORK_TITLE
,      AUTHORIZED_BY_PERSON_ID
,      AUTHORIZED_BY_TITLE
,      AWARD_AMOUNT
,      AWARD_PERCENTAGE
,      AWARD_UOM
,      BARGAINING_UNIT_STATUS
,      CITIZENSHIP
,      CONCURRENCE_DATE
,      CUSTOM_PAY_CALC_FLAG
,      DUTY_STATION_CODE
,      DUTY_STATION_DESC
,      DUTY_STATION_ID
,      DUTY_STATION_LOCATION_ID
,      EDUCATION_LEVEL
,      EFFECTIVE_DATE
,      EMPLOYEE_ASSIGNMENT_ID
,      EMPLOYEE_DATE_OF_BIRTH
,      EMPLOYEE_DEPT_OR_AGENCY
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_LAST_NAME
,      EMPLOYEE_MIDDLE_NAMES
,      EMPLOYEE_NATIONAL_IDENTIFIER
,      FEGLI
,      FEGLI_DESC
,      FIRST_ACTION_LA_CODE1
,      FIRST_ACTION_LA_CODE2
,      FIRST_ACTION_LA_DESC1
,      FIRST_ACTION_LA_DESC2
,      FIRST_NOA_CANCEL_OR_CORRECT
,      FIRST_NOA_CANC_PA_REQUEST_ID
,      FIRST_NOA_CODE
,      FIRST_NOA_DESC
,      FIRST_NOA_ID
,      FIRST_NOA_PA_REQUEST_ID
,      FLSA_CATEGORY
,      FORWARDING_ADDRESS_LINE1
,      FORWARDING_ADDRESS_LINE2
,      FORWARDING_ADDRESS_LINE3
,      FORWARDING_COUNTRY
,      FORWARDING_COUNTRY_SHORT_NAME
,      FORWARDING_POSTAL_CODE
,      FORWARDING_REGION_2
,      FORWARDING_TOWN_OR_CITY
,      FROM_ADJ_BASIC_PAY
,      FROM_AGENCY_CODE
,      FROM_AGENCY_DESC
,      FROM_BASIC_PAY
,      FROM_GRADE_OR_LEVEL
,      FROM_LOCALITY_ADJ
,      FROM_OCC_CODE
,      FROM_OFFICE_SYMBOL
,      FROM_OTHER_PAY_AMOUNT
,      FROM_PAY_BASIS
,      FROM_PAY_PLAN
,      FROM_POSITION_ID
,      FROM_POSITION_ORG_LINE1
,      FROM_POSITION_ORG_LINE2
,      FROM_POSITION_ORG_LINE3
,      FROM_POSITION_ORG_LINE4
,      FROM_POSITION_ORG_LINE5
,      FROM_POSITION_ORG_LINE6
,      FROM_POSITION_NUMBER
,      FROM_POSITION_SEQ_NO
,      FROM_POSITION_TITLE
,      FROM_STEP_OR_RATE
,      FROM_TOTAL_SALARY
,      FUNCTIONAL_CLASS
,      NOTEPAD
,      NOTIFICATION_PRINTED_BY
,      NO_OF_NOTIFICATION_PRINTED
,      PART_TIME_HOURS
,      PAY_RATE_DETERMINANT
,      PERSONNEL_OFFICE_ID
,      PERSON_ID
,      POSITION_OCCUPIED
,      PROPOSED_EFFECTIVE_ASAP_FLAG
,      PROPOSED_EFFECTIVE_DATE
,      REQUESTED_BY_PERSON_ID
,      REQUESTED_BY_TITLE
,      REQUESTED_DATE
,      REQUESTING_OFFICE_REMARKS_DESC
,      REQUESTING_OFFICE_REMARKS_FLAG
,      REQUEST_NUMBER
,      RESIGN_AND_RETIRE_REASON_DESC
,      RETIREMENT_PLAN
,      RETIREMENT_PLAN_DESC
,      SECOND_ACTION_LA_CODE1
,      SECOND_ACTION_LA_CODE2
,      SECOND_ACTION_LA_DESC1
,      SECOND_ACTION_LA_DESC2
,      SECOND_NOA_CANCEL_OR_CORRECT
,      SECOND_NOA_CANC_PA_REQUEST_ID
,      SECOND_NOA_CODE
,      SECOND_NOA_DESC
,      SECOND_NOA_ID
,      SECOND_NOA_PA_REQUEST_ID
,      SERVICE_COMP_DATE
,      SF50_APPROVAL_DATE
,      SF50_APPROVING_OFCL_FULL_NAME
,      SF50_APPROVING_OFCL_WORK_TITLE
,      STATUS
,      SUPERVISORY_STATUS
,      TENURE
,      TO_ADJ_BASIC_PAY
,      TO_AP_PREMIUM_PAY_INDICATOR
,      TO_AUO_PREMIUM_PAY_INDICATOR
,      TO_AU_OVERTIME
,      TO_AVAILABILITY_PAY
,      TO_BASIC_PAY
,      TO_GRADE_ID
,      TO_GRADE_OR_LEVEL
,      TO_JOB_ID
,      TO_LOCALITY_ADJ
,      TO_OCC_CODE
,      TO_OFFICE_SYMBOL
,      TO_ORGANIZATION_ID
,      TO_OTHER_PAY_AMOUNT
,      TO_PAY_BASIS
,      TO_PAY_PLAN
,      TO_POSITION_ID
,      TO_POSITION_ORG_LINE1
,      TO_POSITION_ORG_LINE2
,      TO_POSITION_ORG_LINE3
,      TO_POSITION_ORG_LINE4
,      TO_POSITION_ORG_LINE5
,      TO_POSITION_ORG_LINE6
,      TO_POSITION_NUMBER
,      TO_POSITION_SEQ_NO
,      TO_POSITION_TITLE
,      TO_RETENTION_ALLOWANCE
,      TO_RETENTION_ALLOW_PERCENTAGE
,      TO_STAFFING_DIFFERENTIAL
,      TO_STAFFING_DIFF_PERCENTAGE
,      TO_STEP_OR_RATE
,      TO_SUPERVISORY_DIFFERENTIAL
,      TO_SUPERVISORY_DIFF_PERCENTAGE
,      TO_TOTAL_SALARY
,      VETERANS_PREFERENCE
,      VETERANS_PREF_FOR_RIF
,      VETERANS_STATUS
,      WORK_SCHEDULE
,      WORK_SCHEDULE_DESC
,      YEAR_DEGREE_ATTAINED
,      FIRST_NOA_INFORMATION_CAT
,      FIRST_NOA_INFORMATION1
,      FIRST_NOA_INFORMATION2
,      FIRST_NOA_INFORMATION3
,      FIRST_NOA_INFORMATION4
,      FIRST_NOA_INFORMATION5
,      SECOND_LAC1_INFORMATION_CAT
,      SECOND_LAC1_INFORMATION1
,      SECOND_LAC1_INFORMATION2
,      SECOND_LAC1_INFORMATION3
,      SECOND_LAC1_INFORMATION4
,      SECOND_LAC1_INFORMATION5
,      SECOND_LAC2_INFORMATION_CAT
,      SECOND_LAC2_INFORMATION1
,      SECOND_LAC2_INFORMATION2
,      SECOND_LAC2_INFORMATION3
,      SECOND_LAC2_INFORMATION4
,      SECOND_LAC2_INFORMATION5
,      SECOND_NOA_INFORMATION_CAT
,      SECOND_NOA_INFORMATION1
,      SECOND_NOA_INFORMATION2
,      SECOND_NOA_INFORMATION3
,      SECOND_NOA_INFORMATION4
,      SECOND_NOA_INFORMATION5
,      FIRST_LAC1_INFORMATION_CAT
,      FIRST_LAC1_INFORMATION1
,      FIRST_LAC1_INFORMATION2
,      FIRST_LAC1_INFORMATION3
,      FIRST_LAC1_INFORMATION4
,      FIRST_LAC1_INFORMATION5
,      FIRST_LAC2_INFORMATION_CAT
,      FIRST_LAC2_INFORMATION1
,      FIRST_LAC2_INFORMATION2
,      FIRST_LAC2_INFORMATION3
,      FIRST_LAC2_INFORMATION4
,      FIRST_LAC2_INFORMATION5
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      RPA_TYPE
,      MASS_ACTION_ID
,      MASS_ACTION_ELIGIBLE_FLAG
,      MASS_ACTION_SELECT_FLAG
,      MASS_ACTION_COMMENTS
,      AWARD_SALARY
,      PA_INCENTIVE_PAYMENT_OPTION
,      INPUT_PAY_RATE_DETERMINANT
,      FROM_PAY_TABLE_IDENTIFIER
,      TO_PAY_TABLE_IDENTIFIER
,      AUTHORIZED_BY_FULL_NAME
,      REQUESTED_BY_FULL_NAME
FROM HR.GHR_PA_REQUESTS#;

Dependencies

[top of page]

HR.GHR_PA_REQUESTS# references the following:

SchemaHR
TableGHR_PA_REQUESTS
HR.GHR_PA_REQUESTS# is referenced by following:

SchemaAPPS
SynonymGHR_PA_REQUESTS
TriggerGHR_PA_REQUESTS_WHO