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

VIEW: APPS.GHR_PA_REQUESTS_V

Object Details
Object Name: GHR_PA_REQUESTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_PA_REQUESTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PA_REQUEST_ID NUMBER (15) Yes Primary key generated from sequence GHR_PA_REQUESTS_S.
ROW_ID ROWID (10)
Row ID
NOA_FAMILY_CODE VARCHAR2 (30) Yes Nature of action family code.
ACTION_REQUESTED VARCHAR2 (100) Yes Action Requested
ROUTING_GROUP_ID NUMBER (15)
Foreign key to GHR_ROUTING_GROUPS.
ACADEMIC_DISCIPLINE VARCHAR2 (30)
Academic discipline.
ADDITIONAL_INFO_PERSON_ID NUMBER (10)
Foreign key to PER_PEOPLE_F
ADDITIONAL_INFO_TEL_NUMBER VARCHAR2 (60)
Telephone Number of the Person for Additional Information
ALTERED_PA_REQUEST_ID NUMBER (15)
Foreign Key to PER_PEOPLE_F
ANNUITANT_INDICATOR VARCHAR2 (30)
Annuitant indicator.
AUTHORIZED_BY_TITLE VARCHAR2 (240)
Title of authorizer.
APPROPRIATION_CODE1 VARCHAR2 (30)
Appropriation code 1.
APPROPRIATION_CODE2 VARCHAR2 (30)
Appropriation code 2.
AUTHORIZED_BY_PERSON_ID NUMBER (10)
Foreign key to PER_PEOPLE_F.
APPROVAL_DATE DATE

Approval date of the RPA
APPROVING_OFFICIAL_FULL_NAME VARCHAR2 (240)
Full Name of the RPA Approving Official
APPROVING_OFFICIAL_WORK_TITLE VARCHAR2 (60)
Work Title of the RPA Approving Official
BARGAINING_UNIT_STATUS VARCHAR2 (30)
Bargaining unit status.
CITIZENSHIP VARCHAR2 (30)
Citizenship.
CONCURRENCE_DATE DATE

Date of concurrence.
CUSTOM_PAY_CALC_FLAG VARCHAR2 (1)
Flag to indicate if Pay was calculated or need to be entered by user
DUTY_STATION_CODE VARCHAR2 (9)
Duty station code.
DUTY_STATION_DESC VARCHAR2 (150)
Description of the duty station.
DUTY_STATION_ID NUMBER (15)
Foreign key to GHR_DUTY_STATIONS.
DUTY_STATION_LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS.
EDUCATION_LEVEL VARCHAR2 (30)
Education level.
PERSON_ID NUMBER (10)
Foreign key to PER_PEOPLE_F.
EFFECTIVE_DATE DATE

Effective date of Request for Personnel Action.
EMPLOYEE_NATIONAL_IDENTIFIER VARCHAR2 (30)
Employee's national identifier.
EMPLOYEE_DATE_OF_BIRTH DATE

Employee's date of birth.
EMPLOYEE_ASSIGNMENT_ID NUMBER (15)
Foreign key to PER_ASSIGNMENTS_F.
EMPLOYEE_FIRST_NAME VARCHAR2 (150)
Employee?s first name.
EMPLOYEE_LAST_NAME VARCHAR2 (150)
Employee?s last name.
EMPLOYEE_MIDDLE_NAMES VARCHAR2 (60)
Employee?s middle names.
FEGLI VARCHAR2 (30)
Federal employee?s group life insurance.
FIRST_ACTION_LA_CODE1 VARCHAR2 (30)
First action legal authority code 1.
FIRST_ACTION_LA_CODE2 VARCHAR2 (30)
First action legal authority code 2.
FIRST_ACTION_LA_DESC1 VARCHAR2 (240)
Description of the first action legal authority code 1.
FIRST_ACTION_LA_DESC2 VARCHAR2 (240)
Description of the first action legal authority code 2.
FIRST_NOA_CANCEL_OR_CORRECT VARCHAR2 (10)
Indicates whether First Action has been canceled or corrected.
FIRST_NOA_CODE VARCHAR2 (4)
First nature of action code.
FIRST_NOA_DESC VARCHAR2 (240)
Description of the first nature of action code.
FIRST_NOA_ID NUMBER (15)
Foreign key to GHR_NATURE_OF_ACTIONS.
FIRST_NOA_PA_REQUEST_ID NUMBER (15)
Foreign key to GHR_PA_REQUESTS, request for personnel action for cancellation / correction of first action.
FLSA_CATEGORY VARCHAR2 (30)
Fair labor standards act.
FORWARDING_ADDRESS_LINE1 VARCHAR2 (240)
Forwarding address line 1.
FORWARDING_ADDRESS_LINE2 VARCHAR2 (240)
Forwarding address line 2.
FORWARDING_ADDRESS_LINE3 VARCHAR2 (240)
Forwarding address line 3.
FORWARDING_COUNTRY VARCHAR2 (60)
Forwarding country.
FORWARDING_COUNTRY_SHORT_NAME VARCHAR2 (80)
Forwarding country short name.
FORWARDING_POSTAL_CODE VARCHAR2 (30)
Forwarding postal code.
FORWARDING_REGION_2 VARCHAR2 (120)
Forwarding region 2.
FORWARDING_TOWN_OR_CITY VARCHAR2 (30)
Forwarding town or city.
FROM_ADJ_BASIC_PAY NUMBER (15)
From adjusted basic pay.
FROM_AGENCY_CODE VARCHAR2 (30)
From agency code.
FROM_AGENCY_DESC VARCHAR2 (80)
Description of the from agency code.
FROM_BASIC_PAY NUMBER (15)
From basic pay.
FROM_GRADE_OR_LEVEL VARCHAR2 (30)
From grade or level.
FROM_LOCALITY_ADJ NUMBER (15)
From locality adjustment.
FROM_OCC_CODE VARCHAR2 (150)
From occupational code.
FROM_OFFICE_SYMBOL VARCHAR2 (30)
From office symbol.
FROM_OTHER_PAY_AMOUNT NUMBER (15)
From other pay amount.
FROM_PAY_BASIS VARCHAR2 (30)
From pay basis.
FROM_PAY_PLAN VARCHAR2 (2)
From pay plan.
FROM_POSITION_ID NUMBER (15)
Foreign key to PER_POSITIONS.
FROM_POSITION_ORG_LINE1 VARCHAR2 (40)
From position?s organization line 1.
FROM_POSITION_ORG_LINE2 VARCHAR2 (40)
From position?s organization line 2.
FROM_POSITION_ORG_LINE3 VARCHAR2 (40)
From position?s organization line 3.
FROM_POSITION_ORG_LINE4 VARCHAR2 (40)
From position?s organization line 4.
FROM_POSITION_ORG_LINE5 VARCHAR2 (40)
From position?s organization line 5.
FROM_POSITION_ORG_LINE6 VARCHAR2 (40)
From position?s organization line 6.
FROM_POSITION_NUMBER VARCHAR2 (15)
From position number.
FROM_POSITION_SEQ_NO NUMBER (15)
From Position Sequence Number
FROM_POSITION_TITLE VARCHAR2 (240)
From Position Title
FROM_STEP_OR_RATE VARCHAR2 (30)
From Step Or rate
FROM_TOTAL_SALARY NUMBER (15)
From Total Salary
FUNCTIONAL_CLASS VARCHAR2 (30)
Functional Class
AWARD_AMOUNT NUMBER (15)
Award Amount
AWARD_UOM VARCHAR2 (30)
Award Unit of measure
AWARD_PERCENTAGE NUMBER (5)
Award Percentage
NOTEPAD VARCHAR2 (2000)
Notepad Information
PA_NOTIFICATION_ID NUMBER (22)
Personnel Action Notification ID
PART_TIME_HOURS NUMBER (5)
Part time hours
PAY_RATE_DETERMINANT VARCHAR2 (30)
Pay Rate Determinant
REQUESTED_BY_TITLE VARCHAR2 (240)
Requested By Title
POSITION_OCCUPIED VARCHAR2 (30)
Position Occupied
PROPOSED_EFFECTIVE_DATE DATE

Proposed Effective Date
PROPOSED_EFFECTIVE_ASAP_FLAG VARCHAR2 (1) Yes Proposed Effective ASAP Flag
REQUEST_NUMBER VARCHAR2 (25)
Request Number
REQUESTED_BY_PERSON_ID NUMBER (10)
Requested by Person ID
REQUESTED_DATE DATE

Requested Date
REQUESTING_OFFICE_REMARKS_DESC VARCHAR2 (2000)
Requesting Office Remarks Description
REQUESTING_OFFICE_REMARKS_FLAG VARCHAR2 (1)
Requesting Office Remarks Flag
RESIGN_AND_RETIRE_REASON_DESC VARCHAR2 (2000)
Resign and Retire reason Description
RETIREMENT_PLAN VARCHAR2 (30)
Retirement Plan
SECOND_ACTION_LA_CODE1 VARCHAR2 (30)
Second Action Legal Authority Code1
SECOND_ACTION_LA_CODE2 VARCHAR2 (30)
Second Action Legal Authority Code2
SECOND_ACTION_LA_DESC1 VARCHAR2 (240)
Second Action Legal Authority Code1 Description
SECOND_ACTION_LA_DESC2 VARCHAR2 (240)
Second Action Legal Authority Code2 Description
SECOND_NOA_CANCEL_OR_CORRECT VARCHAR2 (10)
Second NOA Cancel or Correct
SECOND_NOA_CODE VARCHAR2 (4)
Second NOA Code
SECOND_NOA_DESC VARCHAR2 (240)
Second NOA Description
SECOND_NOA_ID NUMBER (15)
Second NOA ID
SECOND_NOA_PA_REQUEST_ID NUMBER (15)
Second NOA Personnel Action Request ID
SERVICE_COMP_DATE DATE

Service Comp Date
STATUS VARCHAR2 (30)
Status
SUPERVISORY_STATUS VARCHAR2 (30)
Supervisory Status
TENURE VARCHAR2 (30)
Tenure
TO_ADJ_BASIC_PAY NUMBER (15)
To Adjusted basic Pay
TO_BASIC_PAY NUMBER (15)
To Basic Pay
TO_LOCALITY_ADJ NUMBER (15)
To Locality Adjustment
TO_GRADE_ID NUMBER (15)
To Grade ID
TO_GRADE_OR_LEVEL VARCHAR2 (30)
TO Grade Or Level
TO_JOB_ID NUMBER (15)
To Job ID
TO_ORGANIZATION_ID NUMBER (15)
To Organization ID
TO_POSITION_ORG_LINE1 VARCHAR2 (40)
To Position Organization Line1
TO_POSITION_ORG_LINE2 VARCHAR2 (40)
To Position Organization Line2
TO_POSITION_ORG_LINE3 VARCHAR2 (40)
To Position Organization Line3
TO_POSITION_ORG_LINE4 VARCHAR2 (40)
To Position Organization Line4
TO_POSITION_ORG_LINE5 VARCHAR2 (40)
To Position Organization Line5
TO_POSITION_ORG_LINE6 VARCHAR2 (40)
To Position Organization Line6
TO_POSITION_NUMBER VARCHAR2 (15)
To Position Number
TO_POSITION_SEQ_NO NUMBER (15)
To Position Sequence Number
TO_POSITION_TITLE VARCHAR2 (240)
To Position Title
TO_OCC_CODE VARCHAR2 (30)
To Occupation Code
TO_OTHER_PAY_AMOUNT NUMBER (15)
To Other Pay Amount
TO_AU_OVERTIME NUMBER (15)
To AU Overtime
TO_AUO_PREMIUM_PAY_INDICATOR VARCHAR2 (30)
To AUO Premium Pay Indicator
TO_AVAILABILITY_PAY NUMBER (15)
To Availability Pay
TO_AP_PREMIUM_PAY_INDICATOR VARCHAR2 (30)
To Availability Pay Indicator
TO_RETENTION_ALLOWANCE NUMBER (15)
To Retention Allowance
TO_RETENTION_ALLOW_PERCENTAGE NUMBER (5)
To Retention Allowance Percentage
TO_SUPERVISORY_DIFFERENTIAL NUMBER (15)
To Supervisory Differential
TO_SUPERVISORY_DIFF_PERCENTAGE NUMBER (5)
To Supervisory Differential Percentage
TO_STAFFING_DIFFERENTIAL NUMBER (15)
To Staffing Differentail
TO_STAFFING_DIFF_PERCENTAGE NUMBER (5)
To Staffing Differentail Percentage
TO_PAY_BASIS VARCHAR2 (30)
To Pay Basis
TO_PAY_PLAN VARCHAR2 (2)
To Pay Plan
TO_POSITION_ID NUMBER (15)
To Position ID
TO_STEP_OR_RATE VARCHAR2 (30)
To Step Or Rate
TO_TOTAL_SALARY NUMBER (15)
To Total Salary
VETERANS_PREF_FOR_RIF VARCHAR2 (30)
Veterans Preference For RIF
VETERANS_PREFERENCE VARCHAR2 (30)
Veterans Preference
VETERANS_STATUS VARCHAR2 (30)
Veterans Status
WORK_SCHEDULE VARCHAR2 (30)
Work Schedule
YEAR_DEGREE_ATTAINED NUMBER (4)
Year Degree Attained
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flex Field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flex Field
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flex Field
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
LAST_UPDATE_DATE DATE
Yes Who Column
LAST_UPDATED_BY NUMBER (15) Yes Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Who Column
CREATED_BY NUMBER (15) Yes Who Column
CREATION_DATE DATE
Yes Who Column
FIRST_NOA_INFORMATION_CAT VARCHAR2 (4)
Nature of action Information Category
FIRST_NOA_INFORMATION1 VARCHAR2 (240)
Nature of Action insertion value1
FIRST_NOA_INFORMATION2 VARCHAR2 (150)
Nature of Action insertion value2
FIRST_NOA_INFORMATION3 VARCHAR2 (150)
Nature of Action insertion value3
FIRST_NOA_INFORMATION4 VARCHAR2 (150)
Nature of Action insertion value4
FIRST_NOA_INFORMATION5 VARCHAR2 (150)
Nature of Action insertion value5
FIRST_LAC1_INFORMATION_CAT VARCHAR2 (30)
First Legal Authority Code1 Category
FIRST_LAC1_INFORMATION1 VARCHAR2 (240)
First Legal Authority Code1 Insertion Value1
FIRST_LAC1_INFORMATION2 VARCHAR2 (150)
First Legal Authority Code1 Insertion Value2
FIRST_LAC1_INFORMATION3 VARCHAR2 (150)
First Legal Authority Code1 Insertion Value3
FIRST_LAC1_INFORMATION4 VARCHAR2 (150)
First Legal Authority Code1 Insertion Value4
FIRST_LAC1_INFORMATION5 VARCHAR2 (150)
First Legal Authority Code1 Insertion Value5
FIRST_LAC2_INFORMATION_CAT VARCHAR2 (30)
First Legal Authority Code2 Category
FIRST_LAC2_INFORMATION1 VARCHAR2 (240)
First Legal Authority Code2 Insertion Value1
FIRST_LAC2_INFORMATION2 VARCHAR2 (150)
First Legal Authority Code2 Insertion Value2
FIRST_LAC2_INFORMATION3 VARCHAR2 (150)
First Legal Authority Code2 Insertion Value3
FIRST_LAC2_INFORMATION4 VARCHAR2 (150)
First Legal Authority Code2 Insertion Value4
FIRST_LAC2_INFORMATION5 VARCHAR2 (150)
First Legal Authority Code2 Insertion Value5
SECOND_NOA_INFORMATION_CAT VARCHAR2 (4)
Second Nature of Action Category
SECOND_NOA_INFORMATION1 VARCHAR2 (240)
Second Nature of action insertion value1
SECOND_NOA_INFORMATION2 VARCHAR2 (150)
Second Nature of action insertion value2
SECOND_NOA_INFORMATION3 VARCHAR2 (150)
Second Nature of action insertion value3
SECOND_NOA_INFORMATION4 VARCHAR2 (150)
Second Nature of action insertion value4
SECOND_NOA_INFORMATION5 VARCHAR2 (150)
Second Nature of action insertion value5
SECOND_LAC1_INFORMATION_CAT VARCHAR2 (30)
Second Legal Authority Code1 Category
SECOND_LAC1_INFORMATION1 VARCHAR2 (240)
Second Legal Authority Code1 Insertion Value1
SECOND_LAC1_INFORMATION2 VARCHAR2 (150)
Second Legal Authority Code1 Insertion Value2
SECOND_LAC1_INFORMATION3 VARCHAR2 (150)
Second Legal Authority Code1 Insertion Value3
SECOND_LAC1_INFORMATION4 VARCHAR2 (150)
Second Legal Authority Code1 Insertion Value4
SECOND_LAC1_INFORMATION5 VARCHAR2 (150)
Second Legal Authority Code1 Insertion Value5
SECOND_LAC2_INFORMATION_CAT VARCHAR2 (30)
Second Legal Authority Code2 Category
SECOND_LAC2_INFORMATION1 VARCHAR2 (240)
Second Legal Authority Code2 Insertion Value1
SECOND_LAC2_INFORMATION2 VARCHAR2 (150)
Second Legal Authority Code2 Insertion Value2
SECOND_LAC2_INFORMATION3 VARCHAR2 (150)
Second Legal Authority Code2 Insertion Value3
SECOND_LAC2_INFORMATION4 VARCHAR2 (150)
Second Legal Authority Code2 Insertion Value4
SECOND_LAC2_INFORMATION5 VARCHAR2 (150)
Second Legal Authority Code2 Insertion Value5
NOTIFICATION_PRINTED_BY NUMBER (15)
Notification Printed by
FROM_PAY_TABLE_IDENTIFIER NUMBER (9)
INPUT_PAY_RATE_DETERMINANT VARCHAR2 (30)
TO_PAY_TABLE_IDENTIFIER NUMBER (9)
AWARD_SALARY NUMBER (15)
PA_INCENTIVE_PAYMENT_OPTION VARCHAR2 (1)
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
,      ROW_ID
,      NOA_FAMILY_CODE
,      ACTION_REQUESTED
,      ROUTING_GROUP_ID
,      ACADEMIC_DISCIPLINE
,      ADDITIONAL_INFO_PERSON_ID
,      ADDITIONAL_INFO_TEL_NUMBER
,      ALTERED_PA_REQUEST_ID
,      ANNUITANT_INDICATOR
,      AUTHORIZED_BY_TITLE
,      APPROPRIATION_CODE1
,      APPROPRIATION_CODE2
,      AUTHORIZED_BY_PERSON_ID
,      APPROVAL_DATE
,      APPROVING_OFFICIAL_FULL_NAME
,      APPROVING_OFFICIAL_WORK_TITLE
,      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
,      PERSON_ID
,      EFFECTIVE_DATE
,      EMPLOYEE_NATIONAL_IDENTIFIER
,      EMPLOYEE_DATE_OF_BIRTH
,      EMPLOYEE_ASSIGNMENT_ID
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_LAST_NAME
,      EMPLOYEE_MIDDLE_NAMES
,      FEGLI
,      FIRST_ACTION_LA_CODE1
,      FIRST_ACTION_LA_CODE2
,      FIRST_ACTION_LA_DESC1
,      FIRST_ACTION_LA_DESC2
,      FIRST_NOA_CANCEL_OR_CORRECT
,      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
,      AWARD_AMOUNT
,      AWARD_UOM
,      AWARD_PERCENTAGE
,      NOTEPAD
,      PA_NOTIFICATION_ID
,      PART_TIME_HOURS
,      PAY_RATE_DETERMINANT
,      REQUESTED_BY_TITLE
,      POSITION_OCCUPIED
,      PROPOSED_EFFECTIVE_DATE
,      PROPOSED_EFFECTIVE_ASAP_FLAG
,      REQUEST_NUMBER
,      REQUESTED_BY_PERSON_ID
,      REQUESTED_DATE
,      REQUESTING_OFFICE_REMARKS_DESC
,      REQUESTING_OFFICE_REMARKS_FLAG
,      RESIGN_AND_RETIRE_REASON_DESC
,      RETIREMENT_PLAN
,      SECOND_ACTION_LA_CODE1
,      SECOND_ACTION_LA_CODE2
,      SECOND_ACTION_LA_DESC1
,      SECOND_ACTION_LA_DESC2
,      SECOND_NOA_CANCEL_OR_CORRECT
,      SECOND_NOA_CODE
,      SECOND_NOA_DESC
,      SECOND_NOA_ID
,      SECOND_NOA_PA_REQUEST_ID
,      SERVICE_COMP_DATE
,      STATUS
,      SUPERVISORY_STATUS
,      TENURE
,      TO_ADJ_BASIC_PAY
,      TO_BASIC_PAY
,      TO_LOCALITY_ADJ
,      TO_GRADE_ID
,      TO_GRADE_OR_LEVEL
,      TO_JOB_ID
,      TO_ORGANIZATION_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_OCC_CODE
,      TO_OTHER_PAY_AMOUNT
,      TO_AU_OVERTIME
,      TO_AUO_PREMIUM_PAY_INDICATOR
,      TO_AVAILABILITY_PAY
,      TO_AP_PREMIUM_PAY_INDICATOR
,      TO_RETENTION_ALLOWANCE
,      TO_RETENTION_ALLOW_PERCENTAGE
,      TO_SUPERVISORY_DIFFERENTIAL
,      TO_SUPERVISORY_DIFF_PERCENTAGE
,      TO_STAFFING_DIFFERENTIAL
,      TO_STAFFING_DIFF_PERCENTAGE
,      TO_PAY_BASIS
,      TO_PAY_PLAN
,      TO_POSITION_ID
,      TO_STEP_OR_RATE
,      TO_TOTAL_SALARY
,      VETERANS_PREF_FOR_RIF
,      VETERANS_PREFERENCE
,      VETERANS_STATUS
,      WORK_SCHEDULE
,      YEAR_DEGREE_ATTAINED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      FIRST_NOA_INFORMATION_CAT
,      FIRST_NOA_INFORMATION1
,      FIRST_NOA_INFORMATION2
,      FIRST_NOA_INFORMATION3
,      FIRST_NOA_INFORMATION4
,      FIRST_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
,      SECOND_NOA_INFORMATION_CAT
,      SECOND_NOA_INFORMATION1
,      SECOND_NOA_INFORMATION2
,      SECOND_NOA_INFORMATION3
,      SECOND_NOA_INFORMATION4
,      SECOND_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
,      NOTIFICATION_PRINTED_BY
,      FROM_PAY_TABLE_IDENTIFIER
,      INPUT_PAY_RATE_DETERMINANT
,      TO_PAY_TABLE_IDENTIFIER
,      AWARD_SALARY
,      PA_INCENTIVE_PAYMENT_OPTION
,      AUTHORIZED_BY_FULL_NAME
,      REQUESTED_BY_FULL_NAME
FROM APPS.GHR_PA_REQUESTS_V;

Dependencies

[top of page]

APPS.GHR_PA_REQUESTS_V references the following:

SchemaAPPS
SynonymGHR_FAMILIES
SynonymGHR_NATURE_OF_ACTIONS
SynonymGHR_PA_REQUESTS

APPS.GHR_PA_REQUESTS_V is not referenced by any database object