VIEW: APPS.HXTFV_HOLIDAY_CALENDARS

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 ,hcl.name holiday_calendar ,hcl.description holiday_calendar_description ,hhd.holiday_date holiday_date ,hhd.hours holiday_day_hours ,hhdT.name holiday_day ,org.name organization_name ,pet.element_name element_name /********/ /* Ids */ /********/ ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,hcl.element_type_id element_type_id ,asg.grade_id grade_id ,hcl.id holiday_calendar_id ,hhd.id holiday_day_id ,asg.job_id job_id ,hcl.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_earning_policies epl ,hxt_holiday_calendars hcl ,hxt_holiday_days hhd ,hxt_holiday_days_tl hhdT ,hr_all_organization_units_tl org ,pay_element_types_f pet ,hr_all_organization_units_tl bgrT WHERE SYSDATE BETWEEN pet.effective_start_date AND pet.effective_end_date 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 epl.effective_start_date AND epl.effective_end_date 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 asg.person_id = peo.person_id AND aif.assignment_id = asg.assignment_id AND epl.id = aif.earning_policy AND epl.hcl_id = hcl.id AND hcl.id = hhd.hcl_id AND hhd.id = hhdT.id AND hhdT.language = userenv('LANG') AND hcl.organization_id = org.organization_id (+) AND org.language (+) = userenv('LANG') AND hcl.element_type_id = pet.element_type_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
, EPL.NAME EARNING_POLICY
, HCL.NAME HOLIDAY_CALENDAR
, HCL.DESCRIPTION HOLIDAY_CALENDAR_DESCRIPTION
, HHD.HOLIDAY_DATE HOLIDAY_DATE
, HHD.HOURS HOLIDAY_DAY_HOURS
, HHDT.NAME HOLIDAY_DAY
, ORG.NAME ORGANIZATION_NAME
, PET.ELEMENT_NAME ELEMENT_NAME /********/ /* IDS */ /********/
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HCL.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ASG.GRADE_ID GRADE_ID
, HCL.ID HOLIDAY_CALENDAR_ID
, HHD.ID HOLIDAY_DAY_ID
, ASG.JOB_ID JOB_ID
, HCL.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_EARNING_POLICIES EPL
, HXT_HOLIDAY_CALENDARS HCL
, HXT_HOLIDAY_DAYS HHD
, HXT_HOLIDAY_DAYS_TL HHDT
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PAY_ELEMENT_TYPES_F PET
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE SYSDATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
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 EPL.EFFECTIVE_START_DATE
AND EPL.EFFECTIVE_END_DATE
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 ASG.PERSON_ID = PEO.PERSON_ID
AND AIF.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND EPL.ID = AIF.EARNING_POLICY
AND EPL.HCL_ID = HCL.ID
AND HCL.ID = HHD.HCL_ID
AND HHD.ID = HHDT.ID
AND HHDT.LANGUAGE = USERENV('LANG')
AND HCL.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND ORG.LANGUAGE (+) = USERENV('LANG')
AND HCL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID WITH READ ONLY