View: GHR_SS_SAL_CHG_DATES_V

Product:	GHR - US Federal Human Resources
Description:
Implementation/DBA Data:	APPS.GHR_SS_SAL_CHG_DATES_V

View Text

SELECT DISTINCT EEF.EFFECTIVE_START_DATE START_DATE
, PERALLASSIGNMENTSFEO.PERSON_ID PERSON_ID
, PERALLASSIGNMENTSFEO.ASSIGNMENT_ID ASSIGNMENT_ID
, PERALLASSIGNMENTSFEO.PRIMARY_FLAG PRIMARY_FLAG
, PERALLASSIGNMENTSFEO.ASSIGNMENT_NUMBER
, PERALLASSIGNMENTSFEO.LOCATION_ID
, PERALLASSIGNMENTSFEO.BUSINESS_GROUP_ID
FROM PER_ASSIGNMENTS_F2 PERALLASSIGNMENTSFEO
, PAY_ELEMENT_ENTRIES_F EEF
, PAY_ELEMENT_TYPES_F ELT
WHERE PERALLASSIGNMENTSFEO.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND EEF.ASSIGNMENT_ID = PERALLASSIGNMENTSFEO.ASSIGNMENT_ID
AND EEF.EFFECTIVE_START_DATE BETWEEN PERALLASSIGNMENTSFEO.EFFECTIVE_START_DATE
AND PERALLASSIGNMENTSFEO.EFFECTIVE_END_DATE
AND ELT.ELEMENT_TYPE_ID = EEF.ELEMENT_TYPE_ID
AND EEF.EFFECTIVE_START_DATE BETWEEN ELT.EFFECTIVE_START_DATE
AND ELT.EFFECTIVE_END_DATE
AND UPPER(PQP_FEDHR_USPAY_INT_UTILS.RETURN_OLD_ELEMENT_NAME(ELT.ELEMENT_NAME
, PERALLASSIGNMENTSFEO.BUSINESS_GROUP_ID
, EEF.EFFECTIVE_START_DATE)) IN ('BASIC SALARY RATE'
, 'TOTAL PAY' )

Columns