VIEW: APPS.IRCFV_CANDIDATE_PHONES

Source

View Text - Preformatted

SELECT par.person_name candidate_name ,hr_bis.bis_decode_lookup('PHONE_TYPE',pho.phone_type) phone_type ,pho.phone_number phone_number ,hr_bis.bis_decode_lookup('IRC_CONTACT_TIMES',pho.validity) times_to_call ,pho.date_from date_from ,pho.date_to date_to ,NVL(pho.date_to, hr_general.end_of_time) date_to_nn ,'_DF:PER:PER_PHONES:pho' ,pho.phone_type phone_type_code ,pho.validity validity_code ,pho.party_id party_id ,pho.phone_id phone_id FROM hz_person_profiles par ,irc_notification_preferences inp ,per_phones pho WHERE par.party_id = pho.party_id AND inp.party_id = par.party_id AND inp.allow_access = 'Y' AND trunc(sysdate) between NVL(par.effective_start_date, hr_general.start_of_time) and NVL(par.effective_end_date , hr_general.end_of_time) WITH READ ONLY

View Text - HTML Formatted

SELECT PAR.PERSON_NAME CANDIDATE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PHONE_TYPE'
, PHO.PHONE_TYPE) PHONE_TYPE
, PHO.PHONE_NUMBER PHONE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('IRC_CONTACT_TIMES'
, PHO.VALIDITY) TIMES_TO_CALL
, PHO.DATE_FROM DATE_FROM
, PHO.DATE_TO DATE_TO
, NVL(PHO.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO_NN
, '_DF:PER:PER_PHONES:PHO'
, PHO.PHONE_TYPE PHONE_TYPE_CODE
, PHO.VALIDITY VALIDITY_CODE
, PHO.PARTY_ID PARTY_ID
, PHO.PHONE_ID PHONE_ID
FROM HZ_PERSON_PROFILES PAR
, IRC_NOTIFICATION_PREFERENCES INP
, PER_PHONES PHO
WHERE PAR.PARTY_ID = PHO.PARTY_ID
AND INP.PARTY_ID = PAR.PARTY_ID
AND INP.ALLOW_ACCESS = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(PAR.EFFECTIVE_START_DATE
, HR_GENERAL.START_OF_TIME)
AND NVL(PAR.EFFECTIVE_END_DATE
, HR_GENERAL.END_OF_TIME) WITH READ ONLY