APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_CALENDAR_ENTRIES

Line 19: FROM per_calendar_entries ENT

15: -- data defined.
16: --
17: CURSOR c_osv_ids IS
18: SELECT DISTINCT ENT.org_structure_version_id "OSV_ID"
19: FROM per_calendar_entries ENT
20: WHERE ENT.org_structure_version_id IS NOT NULL
21: AND EXISTS (SELECT 'x'
22: FROM per_cal_entry_values ENV
23: WHERE ENV.calendar_entry_id = ENT.calendar_entry_id

Line 70: FROM per_calendar_entries ENT

66: 'O','OVR') "USAGE"
67: ,ENV.cal_entry_value_id
68: ,ENV.parent_entry_value_id
69: ,'' "ENTRY_FLAG"
70: FROM per_calendar_entries ENT
71: ,per_cal_entry_values ENV
72: WHERE ENT.org_structure_version_id = cp_osv_id
73: AND ENT.calendar_entry_id = ENV.calendar_entry_id
74: AND ENV.org_structure_element_id IS NOT NULL

Line 545: FROM per_calendar_entries ENT

541: -- Cursor to get unique list of GHVs that have calendar entry coverages
542: -- data defined.
543: CURSOR c_ghv_ids IS
544: SELECT DISTINCT ENT.hierarchy_id "GHV_ID"
545: FROM per_calendar_entries ENT
546: WHERE ENT.hierarchy_id IS NOT NULL
547: AND EXISTS (SELECT 'x'
548: FROM per_cal_entry_values ENV
549: WHERE ENV.calendar_entry_id = ENT.calendar_entry_id

Line 597: FROM per_calendar_entries ENT

593: 'O','OVR') "USAGE"
594: ,ENV.cal_entry_value_id
595: ,ENV.parent_entry_value_id
596: ,'' "ENTRY_FLAG"
597: FROM per_calendar_entries ENT
598: ,per_cal_entry_values ENV
599: WHERE ENT.hierarchy_id = cp_ghv_id
600: AND ENT.calendar_entry_id = ENV.calendar_entry_id
601: AND ENV.hierarchy_node_id IS NOT NULL

Line 1153: per_calendar_entries ENT

1149: ENT.start_min,
1150: ENT.end_min,
1151: ORGENT.ovr_cal_entry_value_id
1152: FROM per_cal_entry_org_list ORGENT,
1153: per_calendar_entries ENT
1154: WHERE ORGENT.organization_id = cp_organization_id
1155: AND ORGENT.calendar_entry_id = ENT.calendar_entry_id
1156: AND ENT.type = NVL(cp_event_type, ENT.type)
1157: AND ENT.start_date <= NVL(cp_end_date, ENT.start_date)

Line 1178: per_calendar_entries ENT

1174: ENT.start_min,
1175: ENT.end_min,
1176: GEOENT.ovr_cal_entry_value_id
1177: FROM per_cal_entry_geo_list GEOENT,
1178: per_calendar_entries ENT
1179: WHERE GEOENT.hierarchy_node_id = cp_geo_node_id
1180: AND GEOENT.calendar_entry_id = ENT.calendar_entry_id
1181: AND ENT.type = NVL(cp_event_type, ENT.type)
1182: AND ENT.start_date <= NVL(cp_end_date, ENT.start_date)

Line 1756: FROM per_calendar_entries

1752: start_hour,
1753: end_hour,
1754: start_min,
1755: end_min
1756: FROM per_calendar_entries
1757: WHERE type = NVL(cp_event_type, type)
1758: AND start_date <= NVL(cp_end_date, start_date)
1759: AND end_date >= NVL(cp_start_date, end_date)
1760: AND (business_group_id IS NULL