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 985: DELETE FROM per_cal_entry_org_list;

981: hr_utility.set_location('Entering '||l_proc,10);
982:
983: -- Delete previous event org list records as this execution will
984: -- refresh the list
985: DELETE FROM per_cal_entry_org_list;
986: DELETE FROM per_cal_entry_geo_list;
987:
988: hr_utility.set_location(l_proc,20);
989:

Line 1011: ,tabname => 'PER_CAL_ENTRY_ORG_LIST'

1007:
1008: hr_utility.set_location(l_proc,50);
1009:
1010: fnd_stats.gather_table_stats(ownname => l_table_owner
1011: ,tabname => 'PER_CAL_ENTRY_ORG_LIST'
1012: ,percent => 50
1013: );
1014:
1015: hr_utility.set_location(l_proc,60);

Line 1114: FROM per_cal_entry_org_list ORGENT,

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