1. Tables and Views for HCM
  2. IRC_MP_SEEKER_GEO_PREF_V

IRC_MP_SEEKER_GEO_PREF_V

Details

  • Schema: FUSION

  • Object owner: IRC

  • Object type: VIEW

Columns

Name

PERSON_ID

CONTEXT_ID

JOBS_PROFILE_OPTION_VALUE

Query

SQL_Statement

SELECT

person_id,

context_id,

jobs_profile_option_value

FROM

(

SELECT

sp.person_id AS person_id,

sp.context_id AS context_id,

'N' AS jobs_profile_option_value

FROM

irc_mp_optyseeker_preferences sp

WHERE

sp.context_type = 'ORA_GEOGRAPHY'

AND EXISTS (

SELECT

1

FROM

fnd_profile_option_values ov,

fnd_profile_options_b o

WHERE

o.profile_option_id = ov.profile_option_id

AND o.profile_option_name = 'ORA_HCM_OPP_MARKET_PLACE_JOBS'

AND ov.profile_option_value = 'N'

)

UNION ALL

SELECT

cp.person_id AS person_id,

cpl.geography_id AS context_id,

'Y' AS jobs_profile_option_value

FROM

irc_cand_preferences cp,

irc_cand_pref_locations cpl

WHERE

cp.site_number = 'ICE'

AND cp.cand_pref_id = cpl.cand_pref_id

AND cp.person_id IN (

SELECT

person_id

FROM

irc_mp_seeker_v

)

AND EXISTS (

SELECT

1

FROM

fnd_profile_option_values ov,

fnd_profile_options_b o

WHERE

o.profile_option_id = ov.profile_option_id

AND o.profile_option_name = 'ORA_HCM_OPP_MARKET_PLACE_JOBS'

AND ov.profile_option_value = 'Y'

)

)