APPS.PER_CA_EMP_EQUITY_PKG dependencies on HR_LOCATIONS_ALL

Line 421: from hr_locations_all hloc,

417: 'YT','20',
418: 'NT','21',
419: 'NU','22',
420: '98')
421: from hr_locations_all hloc,
422: hr_lookups hl1
423: where hloc.location_id = p_location_code
424: and hl1.lookup_code = hloc.region_1
425: and hl1.lookup_type = 'CA_PROVINCE';

Line 446: hr_locations_all hloc

442: 'NORTH WEST TERRITORIES','90','NEWFOUNDLAND LESS CMA','91',
443: 'NUNAVUT','92','ONTORIA LESS CMA','93','PRINCE EDWARD ISLAND','94',
444: 'QUEBEC LESS CMA','95','SASKATCHEWAN LESS CMA','96','YUKON TERRITORY','97','OUTSIDE OF CANADA','98')
445: FROM hr_lookups hl1,
446: hr_locations_all hloc
447: WHERE hloc.location_id = p_location_code
448: AND hloc.region_2 = hl1.lookup_code
449: AND hl1.lookup_type = 'CA_CMA';
450: