APPS.HR_CAL_EVENT_MAPPING_PKG dependencies on PER_CAL_ENTRY_ORG_LIST

Line 10: -- events. This procedure refreshes data in table PER_CAL_ENTRY_ORG_LIST.

6: ---------------------------< populate_org_list >-----------------------------
7: -----------------------------------------------------------------------------
8: --
9: -- Private procedure to build mapping data for ORG Hierarchy based calendar
10: -- events. This procedure refreshes data in table PER_CAL_ENTRY_ORG_LIST.
11: --
12: PROCEDURE populate_org_list IS
13: --
14: -- Cursor to get unique list of OSVs that have calendar enrty coverages

Line 209: INSERT INTO per_cal_entry_org_list

205: CLOSE c_org_ovr;
206:
207: hr_utility.set_location(l_proc,18);
208:
209: INSERT INTO per_cal_entry_org_list
210: (calendar_entry_id
211: ,organization_id
212: ,ovr_cal_entry_value_id
213: ,last_update_date

Line 1023: DELETE FROM per_cal_entry_org_list;

1019: hr_utility.set_location('Entering '||l_proc,10);
1020:
1021: -- Delete previous event org list records as this execution will
1022: -- refresh the list
1023: DELETE FROM per_cal_entry_org_list;
1024: DELETE FROM per_cal_entry_geo_list;
1025:
1026: hr_utility.set_location(l_proc,20);
1027:

Line 1049: ,tabname => 'PER_CAL_ENTRY_ORG_LIST'

1045:
1046: hr_utility.set_location(l_proc,50);
1047:
1048: fnd_stats.gather_table_stats(ownname => l_table_owner
1049: ,tabname => 'PER_CAL_ENTRY_ORG_LIST'
1050: ,percent => 50
1051: );
1052:
1053: hr_utility.set_location(l_proc,60);

Line 1152: FROM per_cal_entry_org_list ORGENT,

1148: ENT.end_hour,
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)