DBA Data[Home] [Help]

APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on HR_LOCATIONS_ALL

Line 178: , geometry hr_locations_all.geometry%TYPE

174: , isc_information27 irc_search_criteria.isc_information27%TYPE
175: , isc_information28 irc_search_criteria.isc_information28%TYPE
176: , isc_information29 irc_search_criteria.isc_information29%TYPE
177: , isc_information30 irc_search_criteria.isc_information30%TYPE
178: , geometry hr_locations_all.geometry%TYPE
179: , location_id per_all_vacancies.location_id%TYPE
180: , derived_locale hr_locations_all.derived_locale%TYPE
181: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
182: , business_group_id per_all_vacancies.business_group_id%TYPE

Line 180: , derived_locale hr_locations_all.derived_locale%TYPE

176: , isc_information29 irc_search_criteria.isc_information29%TYPE
177: , isc_information30 irc_search_criteria.isc_information30%TYPE
178: , geometry hr_locations_all.geometry%TYPE
179: , location_id per_all_vacancies.location_id%TYPE
180: , derived_locale hr_locations_all.derived_locale%TYPE
181: , posting_content_id irc_posting_contents_tl.posting_content_id%TYPE
182: , business_group_id per_all_vacancies.business_group_id%TYPE
183: , name per_all_vacancies.name%TYPE
184: , recruiter_id per_all_vacancies.recruiter_id%type

Line 228: p_location_id IN hr_locations_all.LOCATION_ID%TYPE)

224: -- FUNCTIONS
225: -- ----------------------------------------------------------------------------
226: FUNCTION get_location_match
227: ( p_location_to_match IN varchar2,
228: p_location_id IN hr_locations_all.LOCATION_ID%TYPE)
229: RETURN number;
230:
231: FUNCTION convert_vacancy_amount
232: (p_from_currency IN VARCHAR2