View: HRFV_SALARY_PRO

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_SALARY_PRO

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PRO.PROPOSED_SALARY_N SALARY_AMOUNT
, PPB.PAY_ANNUALIZATION_FACTOR ANNUALIZATION_FACTOR
, PPB.PAY_ANNUALIZATION_FACTOR * PRO.PROPOSED_SALARY_N ANNUAL_SALARY
, PET.INPUT_CURRENCY_CODE CURRENCY
, PRO.CHANGE_DATE EFFECTIVE_FROM_DATE
, PRO_NEXT.CHANGE_DATE-1 EFFECTIVE_TO_DATE
, PRO.LAST_CHANGE_DATE SALARY_LAST_CHANGE_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRO.APPROVED) APPROVED
, ASG.NORMAL_HOURS WORKING_HOURS_AMOUNT
, ASG.FREQUENCY WORKING_HOURS_FREQUENCY
, PAY.PAYROLL_NAME PAYROLL
, TPT.NUMBER_PER_FISCAL_YEAR NUMBER_PER_FISCAL_YEAR
, HR_BIS.BIS_DECODE_LOOKUP('PAY_BASIS'
, PPB.PAY_BASIS) PAY_BASIS
, PRO.FORCED_RANKING RANKING
, DECODE(PRO.MULTIPLE_COMPONENTS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRO.MULTIPLE_COMPONENTS)) MULTIPLE_COMPONENTS
, PPB.NAME SALARY_BASES
, '_DF:PER:PER_PAY_PROPOSALS:PRO'
, NVL(PRO_NEXT.CHANGE_DATE-1
, HR_GENERAL.END_OF_TIME) EFFECTIVE_TO_DATE_NN
, PET.INPUT_CURRENCY_CODE CURRENCY_CODE
, PET.OUTPUT_CURRENCY_CODE OUTPUT_CURRENCY_CODE
, PRO.APPROVED APPROVED_CODE
, PPB.PAY_BASIS PAY_BASIS_CODE
, PRO.MULTIPLE_COMPONENTS MULTIPLE_COMPONENTS_CODE
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.PERSON_ID PERSON_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.LOCATION_ID LOCATION_ID
, ASG.JOB_ID JOB_ID
, ASG.GRADE_ID GRADE_ID
, ASG.POSITION_ID POSITION_ID
, PAY.PAYROLL_ID PAYROLL_ID
, PRO.PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, PRO.PERFORMANCE_REVIEW_ID PERFORMANCE_REVIEW_ID
, PRO.EVENT_ID EVENT_ID
, PPB.PAY_BASIS_ID PAY_BASIS_ID
, PPB.INPUT_VALUE_ID INPUT_VALUE_ID
, PPB.RATE_ID RATE_ID
, PET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
FROM PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, PER_PAY_BASES PPB
, PER_PAY_PROPOSALS PRO
, PER_PAY_PROPOSALS PRO_NEXT
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F PET
, PAY_PAYROLLS_F PAY
, PER_TIME_PERIOD_TYPES TPT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
AND PRO.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PRO.CHANGE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG .PERSON_ID = PEO.PERSON_ID
AND PRO.CHANGE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID
AND PRO.ASSIGNMENT_ID = PRO_NEXT.ASSIGNMENT_ID (+)
AND PRO.CHANGE_DATE = PRO_NEXT.LAST_CHANGE_DATE (+)
AND PPB.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PIV.ELEMENT_TYPE_ID= PET.ELEMENT_TYPE_ID
AND PRO.CHANGE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND ASG.PAYROLL_ID= PAY.PAYROLL_ID
AND PRO.CHANGE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE
AND PAY.PERIOD_TYPE = TPT.PERIOD_TYPE
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID =NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns