View: HRFV_SALARY_SURVEY_MAPPINGS

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, ORGT.NAME ORGANIZATION_NAME
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_JOBS'
, JOB.NAME
, NULL) JOB_NAME
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_POSITIONS'
, POS.NAME
, NULL) POSITION_NAME
, GRD.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, HR_BIS.BIS_DECODE_LOOKUP('COMPANY_AGE'
, SSM.COMPANY_AGE_CODE) COMPANY_AGE
, SAS.SURVEY_NAME SURVEY_NAME
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_COMPANY'
, SAS.SURVEY_COMPANY_CODE) SURVEY_COMPANY
, SAS.IDENTIFIER SURVEY_IDENTIFIER
, NULL SURVEY_CURRENCY
, HR_BIS.BIS_DECODE_LOOKUP('PAY_BASIS'
, SAS.SURVEY_TYPE_CODE) SURVEY_TYPE
, SAS.BASE_REGION BASE_REGION
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_JOB_NAME'
, SSL.SURVEY_JOB_NAME_CODE) SURVEY_JOB_NAME
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_REGION'
, SSL.SURVEY_REGION_CODE) SURVEY_REGION
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_SENIORITY'
, SSL.SURVEY_SENIORITY_CODE) SURVEY_SENIORITY
, HR_BIS.BIS_DECODE_LOOKUP('COMPANY_SIZE'
, SSL.COMPANY_SIZE_CODE) COMPANY_SIZE
, HR_BIS.BIS_DECODE_LOOKUP('INDUSTRY'
, SSL.INDUSTRY_CODE) INDUSTRY
, HR_BIS.BIS_DECODE_LOOKUP('SURVEY_AGE'
, SSL.SURVEY_AGE_CODE) SURVEY_AGE
, SSL.START_DATE LINE_START_DATE
, SSL.END_DATE LINE_END_DATE
, SSL.DIFFERENTIAL DIFFERENTIAL
, LINE_CUR.NAME LINE_CURRENCY
, SSL.MINIMUM_PAY MINIMUM_PAY
, SSL.MEAN_PAY MEAN_PAY
, SSL.MAXIMUM_PAY MAXIMUM_PAY
, SSL.GRADUATE_PAY GRADUATE_PAY
, SSL.STARTING_PAY STARTING_PAY
, SSL.PERCENTAGE_CHANGE PERCENTAGE_CHANGE
, SSL.JOB_FIRST_QUARTILE JOB_FIRST_QUARTILE
, SSL.JOB_MEDIAN_QUARTILE JOB_MEDIAN_QUARTILE
, SSL.JOB_THIRD_QUARTILE JOB_THIRD_QUARTILE
, SSL.JOB_FOURTH_QUARTILE JOB_FOURTH_QUARTILE
, SSL.MINIMUM_TOTAL_COMPENSATION MINIMUM_TOTAL_COMPENSATION
, SSL.MEAN_TOTAL_COMPENSATION MEAN_TOTAL_COMPENSATION
, SSL.MAXIMUM_TOTAL_COMPENSATION MAXIMUM_TOTAL_COMPENSATION
, SSL.COMPNSTN_FIRST_QUARTILE COMPENSATION_FIRST_QUARTILE
, SSL.COMPNSTN_MEDIAN_QUARTILE COMPENSATION_MEDIAN_QUARTILE
, SSL.COMPNSTN_THIRD_QUARTILE COMPENSATION_THIRD_QUARTILE
, SSL.COMPNSTN_FOURTH_QUARTILE COMPENSATION_FOURTH_QUARTILE
, '_DF:PER:PER_SALARY_SURVEYS:SAS'
, '_DF:PER:PER_SALARY_SURVEY_LINES:SSL'
, '_DF:PER:PER_SALARY_SURVEY_MAPPINGS:SSM'
, SAS.SALARY_SURVEY_ID SALARY_SURVEY_ID
, SSL.SALARY_SURVEY_LINE_ID SALARY_SURVEY_LINE_ID
, SSM.SALARY_SURVEY_MAPPING_ID SALARY_SURVEY_MAPPING_ID
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_JOBS'
, JOB.JOB_ID
, NULL) JOB_ID
, DECODE(SSM.PARENT_TABLE_NAME
, 'PER_POSITIONS'
, POS.POSITION_ID
, NULL) POSITION_ID
, SSM.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SSM.LOCATION_ID LOCATION_ID
, SSM.GRADE_ID GRADE_ID
, SSM.COMPANY_ORGANIZATION_ID ORGANIZATION_ID
FROM PER_SALARY_SURVEYS SAS
, PER_SALARY_SURVEY_LINES SSL
, PER_SALARY_SURVEY_MAPPINGS SSM
, FND_CURRENCIES_VL LINE_CUR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_LOCATIONS_ALL_TL LOCT
, PER_GRADES GRD
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
WHERE SAS.SALARY_SURVEY_ID = SSL.SALARY_SURVEY_ID
AND SSL.SALARY_SURVEY_LINE_ID = SSM.SALARY_SURVEY_LINE_ID
AND LINE_CUR.CURRENCY_CODE (+) = SSL.CURRENCY_CODE
AND JOB.JOB_ID (+) = SSM.PARENT_ID
AND POS.POSITION_ID (+) = SSM.PARENT_ID
AND SSM.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND SSM.COMPANY_ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND LOCT.LOCATION_ID (+) = SSM.LOCATION_ID
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND GRD.GRADE_ID (+) = SSM.GRADE_ID
AND SSM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, SSM.BUSINESS_GROUP_ID) WITH READ ONLY

Columns