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_SHIFT_POLICY

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 ,sdp.name policy_name ,sdp.description policy_description ,sdp.date_from policy_start ,sdp.date_to policy_end ,sdr.name shift_name ,sdr.start_time shift_start_time ,sdr.stop_time shift_end_time ,sdr.carryover_time carryover_time ,pet.element_name element_name /*******/ /* Ids */ /*******/ ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,sdr.element_type_id element_type_id ,asg.grade_id grade_id ,asg.job_id job_id ,asg.organization_id organization_id ,asg.person_id person_id ,sdp.id policy_id ,asg.position_id position_id FROM per_all_people_f peo ,per_assignments_f asg ,hxt_add_assign_info_f aif ,hxt_shift_diff_policies sdp ,hxt_shift_diff_rules sdr ,pay_element_types_f pet ,hr_all_organization_units_tl bgrT WHERE peo.person_id = asg.person_id AND asg.assignment_id = aif.assignment_id AND aif.shift_differential_policy = sdp.id AND sdr.sdp_id = sdp.id AND sdr.element_type_id = pet.element_type_id (+) AND bgrT.organization_id = asg.business_group_id AND bgrT.language = userenv('LANG') 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 sdr.effective_start_date AND sdr.effective_end_date AND sdr.effective_start_date BETWEEN pet.effective_start_date (+) AND pet.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
, SDP.NAME POLICY_NAME
, SDP.DESCRIPTION POLICY_DESCRIPTION
, SDP.DATE_FROM POLICY_START
, SDP.DATE_TO POLICY_END
, SDR.NAME SHIFT_NAME
, SDR.START_TIME SHIFT_START_TIME
, SDR.STOP_TIME SHIFT_END_TIME
, SDR.CARRYOVER_TIME CARRYOVER_TIME
, PET.ELEMENT_NAME ELEMENT_NAME /*******/ /* IDS */ /*******/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SDR.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, ASG.PERSON_ID PERSON_ID
, SDP.ID POLICY_ID
, ASG.POSITION_ID POSITION_ID
FROM PER_ALL_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HXT_ADD_ASSIGN_INFO_F AIF
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_SHIFT_DIFF_RULES SDR
, PAY_ELEMENT_TYPES_F PET
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AIF.ASSIGNMENT_ID
AND AIF.SHIFT_DIFFERENTIAL_POLICY = SDP.ID
AND SDR.SDP_ID = SDP.ID
AND SDR.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID (+)
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
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 SDR.EFFECTIVE_START_DATE
AND SDR.EFFECTIVE_END_DATE
AND SDR.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE (+)
AND PET.EFFECTIVE_END_DATE (+) WITH READ ONLY