Product: | PER - Human Resources |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.HRFV_CURRENT_SALARIES |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, PPB.PAY_ANNUALIZATION_FACTOR * TO_NUMBER(PEV.SCREEN_ENTRY_VALUE) ANNUAL_SALARY
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, ORGT.NAME ORGANIZATION_NAME
, JOB.NAME JOB_NAME
, POS.NAME POSITION_NAME
, GRD.NAME GRADE_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, PEV.EFFECTIVE_START_DATE CHANGE_DATE
, ROUND(MONTHS_BETWEEN(PEE.EFFECTIVE_START_DATE
, PES.DATE_START)/12) YEARS_SERVICE
, ELT.INPUT_CURRENCY_CODE CURRENCY_CODE
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, GRD.GRADE_ID GRADE_ID
, JOB.JOB_ID JOB_ID
, ORGT.ORGANIZATION_ID ORGANIZATION_ID
, PEO.PERSON_ID PERSON_ID
, POS.POSITION_ID POSITION_ID
, LOCT.LOCATION_ID LOCATION_ID
FROM PAY_ELEMENT_LINKS_X ELL
, PAY_ELEMENT_TYPES_X ELT
, PER_PEOPLE_X PEO
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, PER_JOBS JOB
, PER_ALL_POSITIONS POS
, PER_GRADES GRD
, HR_LOCATIONS_ALL_TL LOCT
, PAY_INPUT_VALUES_X PIV
, PER_PERIODS_OF_SERVICE PES
, PAY_ELEMENT_ENTRY_VALUES_X PEV
, PER_PAY_BASES PPB
, PAY_ELEMENT_ENTRIES_X PEE
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS BGR
, PER_ASSIGNMENTS_X ASG
WHERE BGR.ORGANIZATION_ID = BGR.BUSINESS_GROUP_ID
AND BGR.ORGANIZATION_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND PIV.INPUT_VALUE_ID = PPB.INPUT_VALUE_ID
AND ASG.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND ASG.ASSIGNMENT_TYPE = 'E'
AND ASG.PERIOD_OF_SERVICE_ID = PES.PERIOD_OF_SERVICE_ID
AND ASG.BUSINESS_GROUP_ID = BGR.BUSINESS_GROUP_ID
AND PEE.ELEMENT_ENTRY_ID = PEV.ELEMENT_ENTRY_ID
AND PEV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND PEE.ELEMENT_LINK_ID = ELL.ELEMENT_LINK_ID
AND ELL.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID
AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID
AND PPB.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND ELT.ELEMENT_TYPE_ID = PIV.ELEMENT_TYPE_ID
AND ASG.PERSON_ID = PEO.PERSON_ID
AND PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID)
AND ASG.JOB_ID = JOB.JOB_ID (+)
AND ASG.POSITION_ID = POS.POSITION_ID (+)
AND ASG.GRADE_ID = GRD.GRADE_ID (+)
AND ASG.LOCATION_ID = LOCT.LOCATION_ID (+)
AND LOCT.LANGUAGE (+) = USERENV('LANG') WITH READ ONLY