APPS.HRI_BPL_GEOGRAPHY dependencies on HR_LOCATIONS_ALL

Line 11: TYPE g_region_tabtype IS TABLE OF hr_locations_all.attribute1%TYPE

7: /* Indicates whether all regions are cached */
8: g_all_regions_cached VARCHAR2(1) := 'N';
9:
10: /* Define global table for the collection of location and region code */
11: TYPE g_region_tabtype IS TABLE OF hr_locations_all.attribute1%TYPE
12: INDEX BY BINARY_INTEGER;
13: g_location_region_tab g_region_tabtype; -- cache table
14: g_empty_region_tab g_region_tabtype; -- empty table for resetting cache
15:

Line 68: 'FROM hr_locations_all ' ||

64:
65: /* Set the dynamic cursor */
66: csr_sql_stmt := 'SELECT ' || g_region_segment || ' ' ||
67: ', location_id ' ||
68: 'FROM hr_locations_all ' ||
69: 'WHERE ' || g_region_segment || ' IS NOT NULL';
70: /* Loop through the cursor and populate the cache */
71: OPEN region_cv FOR csr_sql_stmt;
72: LOOP