VIEW: APPS.HXTFV_ADD_ASSIGN_INFO

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 ,hep.name earning_policy ,hep.description earning_policy_description ,hrp.name rotation_plan ,hrp.description rotation_plan_description ,sdp.name shift_differential_policy ,sdp.description shift_policy_description ,hdp.name hour_deduction_policy ,hdp.description hour_policy_description ,hr_general.decode_lookup('YES_NO',aif.AUTOGEN_HOURS_YN) autogen_flag ,aif.attribute_category attribute_category ,'_DF:HXT:HXT_ADD_ASSIGN_INFO_F:aif' /*******/ /* Ids */ /*******/ ,aif.id assignment_info_id ,aif.assignment_id assignment_id ,peo.business_group_id business_group_id ,aif.earning_policy earning_policy_id ,asg.grade_id grade_id ,aif.hour_deduction_policy hour_policy_id ,asg.job_id job_id ,asg.organization_id organization_id ,peo.person_id person_id ,asg.position_id position_id ,aif.rotation_plan rotation_plan_id ,aif.shift_differential_policy shift_policy_id FROM hxt_add_assign_info_f aif ,hxt_earning_policies hep ,hxt_rotation_plans hrp ,hxt_shift_diff_policies sdp ,hxt_hour_deduct_policies hdp ,per_assignments_f asg ,per_all_people_f peo ,hr_all_organization_units_tl bgrT WHERE SYSDATE BETWEEN aif.effective_start_date AND aif.effective_end_date AND SYSDATE BETWEEN peo.effective_start_date AND peo.effective_end_date AND SYSDATE BETWEEN hep.effective_start_date AND hep.effective_end_date AND SYSDATE BETWEEN asg.effective_start_date AND asg.effective_end_date AND peo.person_id = asg.person_id AND asg.assignment_id = aif.assignment_id AND aif.earning_policy = hep.id AND aif.rotation_plan = hrp.id (+) AND aif.shift_differential_policy = sdp.id (+) AND aif.hour_deduction_policy = hdp.id (+) AND peo.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') 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
, HEP.NAME EARNING_POLICY
, HEP.DESCRIPTION EARNING_POLICY_DESCRIPTION
, HRP.NAME ROTATION_PLAN
, HRP.DESCRIPTION ROTATION_PLAN_DESCRIPTION
, SDP.NAME SHIFT_DIFFERENTIAL_POLICY
, SDP.DESCRIPTION SHIFT_POLICY_DESCRIPTION
, HDP.NAME HOUR_DEDUCTION_POLICY
, HDP.DESCRIPTION HOUR_POLICY_DESCRIPTION
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, AIF.AUTOGEN_HOURS_YN) AUTOGEN_FLAG
, AIF.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, '_DF:HXT:HXT_ADD_ASSIGN_INFO_F:AIF' /*******/ /* IDS */ /*******/
, AIF.ID ASSIGNMENT_INFO_ID
, AIF.ASSIGNMENT_ID ASSIGNMENT_ID
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, AIF.EARNING_POLICY EARNING_POLICY_ID
, ASG.GRADE_ID GRADE_ID
, AIF.HOUR_DEDUCTION_POLICY HOUR_POLICY_ID
, ASG.JOB_ID JOB_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, PEO.PERSON_ID PERSON_ID
, ASG.POSITION_ID POSITION_ID
, AIF.ROTATION_PLAN ROTATION_PLAN_ID
, AIF.SHIFT_DIFFERENTIAL_POLICY SHIFT_POLICY_ID
FROM HXT_ADD_ASSIGN_INFO_F AIF
, HXT_EARNING_POLICIES HEP
, HXT_ROTATION_PLANS HRP
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_HOUR_DEDUCT_POLICIES HDP
, PER_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PEO
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE SYSDATE BETWEEN AIF.EFFECTIVE_START_DATE
AND AIF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN HEP.EFFECTIVE_START_DATE
AND HEP.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND PEO.PERSON_ID = ASG.PERSON_ID
AND ASG.ASSIGNMENT_ID = AIF.ASSIGNMENT_ID
AND AIF.EARNING_POLICY = HEP.ID
AND AIF.ROTATION_PLAN = HRP.ID (+)
AND AIF.SHIFT_DIFFERENTIAL_POLICY = SDP.ID (+)
AND AIF.HOUR_DEDUCTION_POLICY = HDP.ID (+)
AND PEO.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY