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_HOURS_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 ,hdp.name policy_name ,hdp.description policy_description ,hdp.date_from policy_start ,hdp.date_to policy_end ,hr_general.decode_lookup('HXT_HOUR_DEDUCTION_TYPE',hdr.fcl_deduction_type) deduction_type ,hdr.hours hours ,hdr.time_period time_period /*******/ /* Ids */ /*******/ ,hdp.id policy_id ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,asg.grade_id grade_id ,asg.job_id job_id ,asg.organization_id organization_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_hour_deduct_policies hdp ,hxt_hour_deduction_rules hdr ,hr_all_organization_units_tl bgrT WHERE peo.person_id = asg.person_id AND asg.assignment_id = aif.assignment_id AND aif.hour_deduction_policy = hdp.id AND hdr.hdp_id = hdp.id AND bgrT.organization_id = asg.business_group_id AND bgrT.language = userenv('LANG') 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 hdr.effective_start_date AND hdr.effective_end_date AND asg.business_group_id = NVL(hr_general.get_business_group_id, asg.business_group_id) 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
, HDP.NAME POLICY_NAME
, HDP.DESCRIPTION POLICY_DESCRIPTION
, HDP.DATE_FROM POLICY_START
, HDP.DATE_TO POLICY_END
, HR_GENERAL.DECODE_LOOKUP('HXT_HOUR_DEDUCTION_TYPE'
, HDR.FCL_DEDUCTION_TYPE) DEDUCTION_TYPE
, HDR.HOURS HOURS
, HDR.TIME_PERIOD TIME_PERIOD /*******/ /* IDS */ /*******/
, HDP.ID POLICY_ID
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG.GRADE_ID GRADE_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_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_HOUR_DEDUCT_POLICIES HDP
, HXT_HOUR_DEDUCTION_RULES HDR
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AIF.ASSIGNMENT_ID
AND AIF.HOUR_DEDUCTION_POLICY = HDP.ID
AND HDR.HDP_ID = HDP.ID
AND BGRT.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND BGRT.LANGUAGE = USERENV('LANG')
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 HDR.EFFECTIVE_START_DATE
AND HDR.EFFECTIVE_END_DATE
AND ASG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY