APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_LOCATIONS_ALL

Line 364: from hr_locations_all hloc,

360: 'YT','20',
361: 'NT','21',
362: 'NU','22',
363: '98')
364: from hr_locations_all hloc,
365: hr_lookups hl1
366: where hloc.location_id = p_location_code
367: and hl1.lookup_code = hloc.region_1
368: and hl1.lookup_type = 'CA_PROVINCE';

Line 389: hr_locations_all hloc

385: 'NORTH WEST TERRITORIES','90','NEWFOUNDLAND LESS CMA','91',
386: 'NUNAVUT','92','ONTORIA LESS CMA','93','PRINCE EDWARD ISLAND','94',
387: 'QUEBEC LESS CMA','95','SASKATCHEWAN LESS CMA','96','YUKON TERRITORY','97')
388: FROM hr_lookups hl1,
389: hr_locations_all hloc
390: WHERE hloc.location_id = p_location_code
391: AND hloc.region_2 = hl1.lookup_code
392: AND hl1.lookup_type = 'CA_CMA';
393: