APPS.HR_CALENDAR_PKG dependencies on HR_CALENDAR_USAGES

Line 755: from hr_calendar_usages USE

751: select use.calendar_usage_id,
752: use.calendar_id,
753: use.start_date,
754: use.end_date
755: from hr_calendar_usages USE
756: where use.purpose_usage_id = p_bg_purpose_usage_id
757: and use.primary_key_value = p_bg_primary_key_value
758: and use.start_date <= p_period_to
759: and use.end_date >= p_period_from

Line 765: from hr_calendar_usages USE

761: select use.calendar_usage_id,
762: use.calendar_id,
763: use.start_date,
764: use.end_date
765: from hr_calendar_usages USE
766: where use.purpose_usage_id = p_person_purpose_usage_id
767: and use.primary_key_value = p_person_primary_key_value
768: and use.start_date <= p_period_to
769: and use.end_date >= p_period_from

Line 834: from hr_calendar_usages USE,

830: select use.calendar_usage_id,
831: use.calendar_id,
832: use.start_date,
833: use.end_date
834: from hr_calendar_usages USE,
835: hr_calendars CAL
836: where use.purpose_usage_id = p_purpose_usage_id
837: and use.primary_key_value = p_primary_key_value
838: and use.start_date <= p_period_to