eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GHR_SS_SAL_CHG_DATES_V

Source

View Text - Preformatted


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' )

View Text - HTML Formatted

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' )