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.HXTFV_EARNING_GROUPS

Source

View Text - Preformatted


SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ bgrT.name business_group_name ,peo.full_name person_name ,1 person_count ,epl.name earning_policy ,pet.element_name element_name ,egt.name earning_group_type ,egt.description group_type_description ,hr_general.decode_lookup('HXT_GROUP_TYPE',egt.fcl_eg_type) group_type /*******/ /* Ids */ /*******/ ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,asg.organization_id organization_id ,egr.egt_id earning_group_type_id ,egr.element_type_id element_type_id ,asg.grade_id grade_id ,asg.job_id job_id ,asg.person_id person_id ,asg.position_id position_id FROM per_all_people_f peo ,per_assignments_f asg ,hxt_add_assign_info_f aif ,hxt_earning_policies epl ,hxt_earn_groups egr ,hxt_earn_group_types egt ,pay_element_types_f pet ,hr_all_organization_units_tl bgrT WHERE asg.person_id = peo.person_id AND aif.assignment_id = asg.assignment_id AND aif.earning_policy = epl.id AND epl.egt_id = egt.id AND egr.egt_id = egt.id AND asg.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND egr.element_type_id = pet.element_type_id AND asg.business_group_id+0 = NVL(hr_general.get_business_group_id,asg.business_group_id) AND SYSDATE BETWEEN peo.effective_start_date AND peo.effective_end_date AND SYSDATE BETWEEN asg.effective_start_date AND asg.effective_end_date AND SYSDATE BETWEEN aif.effective_start_date AND aif.effective_end_date AND SYSDATE BETWEEN pet.effective_start_date AND pet.effective_end_date AND SYSDATE BETWEEN egt.effective_start_date AND egt.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, 1 PERSON_COUNT
, EPL.NAME EARNING_POLICY
, PET.ELEMENT_NAME ELEMENT_NAME
, EGT.NAME EARNING_GROUP_TYPE
, EGT.DESCRIPTION GROUP_TYPE_DESCRIPTION
, HR_GENERAL.DECODE_LOOKUP('HXT_GROUP_TYPE'
, EGT.FCL_EG_TYPE) GROUP_TYPE /*******/ /* IDS */ /*******/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, EGR.EGT_ID EARNING_GROUP_TYPE_ID
, EGR.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AIF
, HXT_EARNING_POLICIES EPL
, HXT_EARN_GROUPS EGR
, HXT_EARN_GROUP_TYPES EGT
, PAY_ELEMENT_TYPES_F PET
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE ASG.PERSON_ID = PEO.PERSON_ID
AND AIF.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND AIF.EARNING_POLICY = EPL.ID
AND EPL.EGT_ID = EGT.ID
AND EGR.EGT_ID = EGT.ID
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND EGR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND ASG.BUSINESS_GROUP_ID+0 = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID)
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN AIF.EFFECTIVE_START_DATE
AND AIF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN EGT.EFFECTIVE_START_DATE
AND EGT.EFFECTIVE_END_DATE WITH READ ONLY