View: HRIFV_SAL_PRO

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:	This gives the Salary based on the Salary Proposal with an effective date range
Implementation/DBA Data:	APPS.HRIFV_SAL_PRO

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ /* ENTITY LEVEL ATTRIBUTES */ 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.OUTPUT_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
, PPB.GRADE_ANNUALIZATION_FACTOR GRADE_ANNUALIZATION_FACTOR /* DERIVED ATTRIBUTES
FROM FOREIGN KEY RESOLUTIONS */
, 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_BASIS /* DESCRIPTIVE FLEXFIELDS */
, '_DF:PER:PER_PAY_PROPOSALS:PRO' /* NOT NULL */
, NVL(PRO_NEXT.CHANGE_DATE-1
, HR_GENERAL.END_OF_TIME) EFFECTIVE_TO_DATE_NN /* CODES */
, PET.OUTPUT_CURRENCY_CODE CURRENCY_CODE
, PRO.APPROVED APPROVED_CODE
, PPB.PAY_BASIS PAY_BASIS_CODE
, PRO.MULTIPLE_COMPONENTS MULTIPLE_COMPONENTS_CODE /* ASG IDS */
, 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 /* OTHER IDS */
, 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 /* SECURE */
, 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 /* SECURE */
, PER_TIME_PERIOD_TYPES TPT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE /* RESTRICTIONS */ PEO.CURRENT_EMPLOYEE_FLAG = 'Y' /* JOINS INC. DATE JOINS */
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 /* ONLY SHOW PEOPLE WHO HAVE A SALARY */
AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID /* NEXT PAY PROPOSAL TO GET DATE */
AND PRO.ASSIGNMENT_ID = PRO_NEXT.ASSIGNMENT_ID (+)
AND PRO.CHANGE_DATE = PRO_NEXT.LAST_CHANGE_DATE (+) /* ELEMENT ENTRY TYPES
AND CURRENCIES */
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 /* PAYROLLS
AND PERIODS */
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 /* BG NAME JOINS */
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG') /* SECURITY RESTRICTIONS */
AND ASG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY

Columns