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 1115: per_calendar_entries ENT

1111: ENT.start_min,
1112: ENT.end_min,
1113: ORGENT.ovr_cal_entry_value_id
1114: FROM per_cal_entry_org_list ORGENT,
1115: per_calendar_entries ENT
1116: WHERE ORGENT.organization_id = cp_organization_id
1117: AND ORGENT.calendar_entry_id = ENT.calendar_entry_id
1118: AND ENT.type = NVL(cp_event_type, ENT.type)
1119: AND ENT.start_date <= NVL(cp_end_date, ENT.start_date)

Line 1140: per_calendar_entries ENT

1136: ENT.start_min,
1137: ENT.end_min,
1138: GEOENT.ovr_cal_entry_value_id
1139: FROM per_cal_entry_geo_list GEOENT,
1140: per_calendar_entries ENT
1141: WHERE GEOENT.hierarchy_node_id = cp_geo_node_id
1142: AND GEOENT.calendar_entry_id = ENT.calendar_entry_id
1143: AND ENT.type = NVL(cp_event_type, ENT.type)
1144: AND ENT.start_date <= NVL(cp_end_date, ENT.start_date)

Line 1718: FROM per_calendar_entries

1714: start_hour,
1715: end_hour,
1716: start_min,
1717: end_min
1718: FROM per_calendar_entries
1719: WHERE type = NVL(cp_event_type, type)
1720: AND start_date <= NVL(cp_end_date, start_date)
1721: AND end_date >= NVL(cp_start_date, end_date)
1722: AND (business_group_id IS NULL