Product: | GHR - US Federal Human Resources |
---|---|
Description: | GHR_PA_REQUESTS_V is a view based on GHR_PA_REQUESTS for use by the form. |
Implementation/DBA Data: | APPS.GHR_PA_REQUESTS_V |
SELECT PA_REQUEST_ID
, PAR.ROWID ROW_ID
, PAR.NOA_FAMILY_CODE
, FAM.NAME ACTION_REQUESTED
, PAR.ROUTING_GROUP_ID
, PAR.ACADEMIC_DISCIPLINE
, PAR.ADDITIONAL_INFO_PERSON_ID
, PAR.ADDITIONAL_INFO_TEL_NUMBER
, PAR.ALTERED_PA_REQUEST_ID
, PAR.ANNUITANT_INDICATOR
, PAR.AUTHORIZED_BY_TITLE
, PAR.APPROPRIATION_CODE1
, PAR.APPROPRIATION_CODE2
, PAR.AUTHORIZED_BY_PERSON_ID
, PAR.APPROVAL_DATE
, PAR.APPROVING_OFFICIAL_FULL_NAME
, PAR.APPROVING_OFFICIAL_WORK_TITLE
, PAR.BARGAINING_UNIT_STATUS
, PAR.CITIZENSHIP
, PAR.CONCURRENCE_DATE
, PAR.CUSTOM_PAY_CALC_FLAG
, PAR.DUTY_STATION_CODE
, PAR.DUTY_STATION_DESC
, PAR.DUTY_STATION_ID
, PAR.DUTY_STATION_LOCATION_ID
, PAR.EDUCATION_LEVEL
, PAR.PERSON_ID
, PAR.EFFECTIVE_DATE
, PAR.EMPLOYEE_NATIONAL_IDENTIFIER
, PAR.EMPLOYEE_DATE_OF_BIRTH
, PAR.EMPLOYEE_ASSIGNMENT_ID
, PAR.EMPLOYEE_FIRST_NAME
, PAR.EMPLOYEE_LAST_NAME
, PAR.EMPLOYEE_MIDDLE_NAMES
, PAR.FEGLI
, PAR.FIRST_ACTION_LA_CODE1
, PAR.FIRST_ACTION_LA_CODE2
, PAR.FIRST_ACTION_LA_DESC1
, PAR.FIRST_ACTION_LA_DESC2
, PAR.FIRST_NOA_CANCEL_OR_CORRECT
, NOA1.CODE FIRST_NOA_CODE
, PAR.FIRST_NOA_DESC
, PAR.FIRST_NOA_ID
, PAR.FIRST_NOA_PA_REQUEST_ID
, PAR.FLSA_CATEGORY
, PAR.FORWARDING_ADDRESS_LINE1
, PAR.FORWARDING_ADDRESS_LINE2
, PAR.FORWARDING_ADDRESS_LINE3
, PAR.FORWARDING_COUNTRY
, PAR.FORWARDING_COUNTRY_SHORT_NAME
, PAR.FORWARDING_POSTAL_CODE
, PAR.FORWARDING_REGION_2
, PAR.FORWARDING_TOWN_OR_CITY
, PAR.FROM_ADJ_BASIC_PAY
, PAR.FROM_AGENCY_CODE
, PAR.FROM_AGENCY_DESC
, PAR.FROM_BASIC_PAY
, PAR.FROM_GRADE_OR_LEVEL
, PAR.FROM_LOCALITY_ADJ
, PAR.FROM_OCC_CODE
, PAR.FROM_OFFICE_SYMBOL
, PAR.FROM_OTHER_PAY_AMOUNT
, PAR.FROM_PAY_BASIS
, PAR.FROM_PAY_PLAN
, PAR.FROM_POSITION_ID
, PAR.FROM_POSITION_ORG_LINE1
, PAR.FROM_POSITION_ORG_LINE2
, PAR.FROM_POSITION_ORG_LINE3
, PAR.FROM_POSITION_ORG_LINE4
, PAR.FROM_POSITION_ORG_LINE5
, PAR.FROM_POSITION_ORG_LINE6
, PAR.FROM_POSITION_NUMBER
, PAR.FROM_POSITION_SEQ_NO
, PAR.FROM_POSITION_TITLE
, PAR.FROM_STEP_OR_RATE
, PAR.FROM_TOTAL_SALARY
, PAR.FUNCTIONAL_CLASS
, PAR.AWARD_AMOUNT
, PAR.AWARD_UOM
, PAR.AWARD_PERCENTAGE
, PAR.NOTEPAD
, PAR.PA_NOTIFICATION_ID
, PAR.PART_TIME_HOURS
, PAR.PAY_RATE_DETERMINANT
, PAR.REQUESTED_BY_TITLE
, PAR.POSITION_OCCUPIED
, PAR.PROPOSED_EFFECTIVE_DATE
, PAR.PROPOSED_EFFECTIVE_ASAP_FLAG
, PAR.REQUEST_NUMBER
, PAR.REQUESTED_BY_PERSON_ID
, PAR.REQUESTED_DATE
, PAR.REQUESTING_OFFICE_REMARKS_DESC
, PAR.REQUESTING_OFFICE_REMARKS_FLAG
, PAR.RESIGN_AND_RETIRE_REASON_DESC
, PAR.RETIREMENT_PLAN
, PAR.SECOND_ACTION_LA_CODE1
, PAR.SECOND_ACTION_LA_CODE2
, PAR.SECOND_ACTION_LA_DESC1
, PAR.SECOND_ACTION_LA_DESC2
, PAR.SECOND_NOA_CANCEL_OR_CORRECT
, NOA2.CODE SECOND_NOA_CODE
, PAR.SECOND_NOA_DESC
, PAR.SECOND_NOA_ID
, PAR.SECOND_NOA_PA_REQUEST_ID
, PAR.SERVICE_COMP_DATE
, PAR.STATUS
, PAR.SUPERVISORY_STATUS
, PAR.TENURE
, PAR.TO_ADJ_BASIC_PAY
, PAR.TO_BASIC_PAY
, PAR.TO_LOCALITY_ADJ
, PAR.TO_GRADE_ID
, PAR.TO_GRADE_OR_LEVEL
, PAR.TO_JOB_ID
, PAR.TO_ORGANIZATION_ID
, PAR.TO_POSITION_ORG_LINE1
, PAR.TO_POSITION_ORG_LINE2
, PAR.TO_POSITION_ORG_LINE3
, PAR.TO_POSITION_ORG_LINE4
, PAR.TO_POSITION_ORG_LINE5
, PAR.TO_POSITION_ORG_LINE6
, PAR.TO_POSITION_NUMBER
, PAR.TO_POSITION_SEQ_NO
, PAR.TO_POSITION_TITLE
, PAR.TO_OCC_CODE
, PAR.TO_OTHER_PAY_AMOUNT
, PAR.TO_AU_OVERTIME
, PAR.TO_AUO_PREMIUM_PAY_INDICATOR
, PAR.TO_AVAILABILITY_PAY
, PAR.TO_AP_PREMIUM_PAY_INDICATOR
, PAR.TO_RETENTION_ALLOWANCE
, PAR.TO_RETENTION_ALLOW_PERCENTAGE
, PAR.TO_SUPERVISORY_DIFFERENTIAL
, PAR.TO_SUPERVISORY_DIFF_PERCENTAGE
, PAR.TO_STAFFING_DIFFERENTIAL
, PAR.TO_STAFFING_DIFF_PERCENTAGE
, PAR.TO_PAY_BASIS
, PAR.TO_PAY_PLAN
, PAR.TO_POSITION_ID
, PAR.TO_STEP_OR_RATE
, PAR.TO_TOTAL_SALARY
, PAR.VETERANS_PREF_FOR_RIF
, PAR.VETERANS_PREFERENCE
, PAR.VETERANS_STATUS
, PAR.WORK_SCHEDULE
, PAR.YEAR_DEGREE_ATTAINED
, PAR.ATTRIBUTE_CATEGORY
, PAR.ATTRIBUTE1
, PAR.ATTRIBUTE2
, PAR.ATTRIBUTE3
, PAR.ATTRIBUTE4
, PAR.ATTRIBUTE5
, PAR.ATTRIBUTE6
, PAR.ATTRIBUTE7
, PAR.ATTRIBUTE8
, PAR.ATTRIBUTE9
, PAR.ATTRIBUTE10
, PAR.ATTRIBUTE11
, PAR.ATTRIBUTE12
, PAR.ATTRIBUTE13
, PAR.ATTRIBUTE14
, PAR.ATTRIBUTE15
, PAR.ATTRIBUTE16
, PAR.ATTRIBUTE17
, PAR.ATTRIBUTE18
, PAR.ATTRIBUTE19
, PAR.ATTRIBUTE20
, PAR.OBJECT_VERSION_NUMBER
, PAR.LAST_UPDATE_DATE
, PAR.LAST_UPDATED_BY
, PAR.LAST_UPDATE_LOGIN
, PAR.CREATED_BY
, PAR.CREATION_DATE
, NOA1.CODE FIRST_NOA_INFORMATION_CAT
, PAR.FIRST_NOA_INFORMATION1
, PAR.FIRST_NOA_INFORMATION2
, PAR.FIRST_NOA_INFORMATION3
, PAR.FIRST_NOA_INFORMATION4
, PAR.FIRST_NOA_INFORMATION5
, PAR.FIRST_ACTION_LA_CODE1 FIRST_LAC1_INFORMATION_CAT
, PAR.FIRST_LAC1_INFORMATION1
, PAR.FIRST_LAC1_INFORMATION2
, PAR.FIRST_LAC1_INFORMATION3
, PAR.FIRST_LAC1_INFORMATION4
, PAR.FIRST_LAC1_INFORMATION5
, PAR.FIRST_ACTION_LA_CODE2 FIRST_LAC2_INFORMATION_CAT
, PAR.FIRST_LAC2_INFORMATION1
, PAR.FIRST_LAC2_INFORMATION2
, PAR.FIRST_LAC2_INFORMATION3
, PAR.FIRST_LAC2_INFORMATION4
, PAR.FIRST_LAC2_INFORMATION5
, NOA2.CODE SECOND_NOA_INFORMATION_CAT
, PAR.SECOND_NOA_INFORMATION1
, PAR.SECOND_NOA_INFORMATION2
, PAR.SECOND_NOA_INFORMATION3
, PAR.SECOND_NOA_INFORMATION4
, PAR.SECOND_NOA_INFORMATION5
, PAR.SECOND_ACTION_LA_CODE1 SECOND_LAC1_INFORMATION_CAT
, PAR.SECOND_LAC1_INFORMATION1
, PAR.SECOND_LAC1_INFORMATION2
, PAR.SECOND_LAC1_INFORMATION3
, PAR.SECOND_LAC1_INFORMATION4
, PAR.SECOND_LAC1_INFORMATION5
, PAR.SECOND_ACTION_LA_CODE2 SECOND_LAC2_INFORMATION_CAT
, PAR.SECOND_LAC2_INFORMATION1
, PAR.SECOND_LAC2_INFORMATION2
, PAR.SECOND_LAC2_INFORMATION3
, PAR.SECOND_LAC2_INFORMATION4
, PAR.SECOND_LAC2_INFORMATION5
, PAR.NOTIFICATION_PRINTED_BY
, PAR.FROM_PAY_TABLE_IDENTIFIER
, PAR.INPUT_PAY_RATE_DETERMINANT
, PAR.TO_PAY_TABLE_IDENTIFIER
FROM GHR_NATURE_OF_ACTIONS NOA2
, GHR_NATURE_OF_ACTIONS NOA1
, GHR_FAMILIES FAM
, GHR_PA_REQUESTS PAR
FROM GHR_NATURE_OF_ACTIONS NOA2
, GHR_NATURE_OF_ACTIONS NOA1
, GHR_FAMILIES FAM
, GHR_PA_REQUESTS PAR
WHERE FAM.NOA_FAMILY_CODE = PAR.NOA_FAMILY_CODE
AND NOA1.NATURE_OF_ACTION_ID(+) = PAR.FIRST_NOA_ID
AND NOA2.NATURE_OF_ACTION_ID(+) = PAR.SECOND_NOA_ID