VIEW: APPS.GHR_PA_REQUESTS_V

Source

View Text - Preformatted

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, PAR.AWARD_SALARY, PAR.PA_INCENTIVE_PAYMENT_OPTION, PAR.AUTHORIZED_BY_FULL_NAME, PAR.REQUESTED_BY_FULL_NAME 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

View Text - HTML Formatted

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
, PAR.AWARD_SALARY
, PAR.PA_INCENTIVE_PAYMENT_OPTION
, PAR.AUTHORIZED_BY_FULL_NAME
, PAR.REQUESTED_BY_FULL_NAME
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