VIEW: APPS.HRFV_RECRUITMENT_ACTIVITIES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,pra.name recruitment_activity_name ,pra.date_start rec_activity_date_start ,pra.date_end rec_activity_date_end ,pra.date_closing rec_activity_date_closing ,TO_NUMBER(pra.planned_cost) planned_cost ,TO_NUMBER(pra.actual_cost) actual_cost ,pra.currency_code currency_code ,pra.external_contact external_contact_name ,pra.contact_telephone_number ext_contact_telephone_number ,pp.full_name internal_contact_name ,pp.employee_number int_contact_employee_number ,hr_bis.bis_decode_lookup('REC_TYPE',pra.type) recruitment_activity_type ,orgT.name coordinating_organization ,hr_bis.bis_decode_lookup('YES_NO',pra.internal_posting) internal_posting ,hr_bis.bis_decode_lookup('YES_NO',pra.external_posting) external_posting ,'_DF:PER:PER_RECRUITMENT_ACTIVITIES:pra' ,pra.business_group_id business_group_id ,orgT.organization_id coordinating_organization_id ,pra.internal_contact_person_id internal_contact_id ,pra.recruitment_activity_id recruitment_activity_id ,pra.posting_content_id posting_content_id ,site_name site_name FROM hr_all_organization_units_tl orgT ,hr_all_organization_units_tl bgrT ,per_people_f pp ,per_recruitment_activities pra ,irc_all_recruiting_sites_tl irsT WHERE pra.internal_contact_person_id = pp.person_id (+) AND pra.run_by_organization_id = orgT.organization_id (+) AND orgT.language (+) = userenv('LANG') AND TRUNC(sysdate) BETWEEN NVL(pp.effective_start_date,TRUNC(sysdate)) AND NVL(pp.effective_end_date, TRUNC(sysdate)) AND pra.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pra.business_group_id) AND pra.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND pra.recruiting_site_id = irsT.recruiting_site_id(+) AND irsT.language(+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PRA.NAME RECRUITMENT_ACTIVITY_NAME
, PRA.DATE_START REC_ACTIVITY_DATE_START
, PRA.DATE_END REC_ACTIVITY_DATE_END
, PRA.DATE_CLOSING REC_ACTIVITY_DATE_CLOSING
, TO_NUMBER(PRA.PLANNED_COST) PLANNED_COST
, TO_NUMBER(PRA.ACTUAL_COST) ACTUAL_COST
, PRA.CURRENCY_CODE CURRENCY_CODE
, PRA.EXTERNAL_CONTACT EXTERNAL_CONTACT_NAME
, PRA.CONTACT_TELEPHONE_NUMBER EXT_CONTACT_TELEPHONE_NUMBER
, PP.FULL_NAME INTERNAL_CONTACT_NAME
, PP.EMPLOYEE_NUMBER INT_CONTACT_EMPLOYEE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('REC_TYPE'
, PRA.TYPE) RECRUITMENT_ACTIVITY_TYPE
, ORGT.NAME COORDINATING_ORGANIZATION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRA.INTERNAL_POSTING) INTERNAL_POSTING
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRA.EXTERNAL_POSTING) EXTERNAL_POSTING
, '_DF:PER:PER_RECRUITMENT_ACTIVITIES:PRA'
, PRA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGT.ORGANIZATION_ID COORDINATING_ORGANIZATION_ID
, PRA.INTERNAL_CONTACT_PERSON_ID INTERNAL_CONTACT_ID
, PRA.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
, PRA.POSTING_CONTENT_ID POSTING_CONTENT_ID
, SITE_NAME SITE_NAME
FROM HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_F PP
, PER_RECRUITMENT_ACTIVITIES PRA
, IRC_ALL_RECRUITING_SITES_TL IRST
WHERE PRA.INTERNAL_CONTACT_PERSON_ID = PP.PERSON_ID (+)
AND PRA.RUN_BY_ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND TRUNC(SYSDATE) BETWEEN NVL(PP.EFFECTIVE_START_DATE
, TRUNC(SYSDATE))
AND NVL(PP.EFFECTIVE_END_DATE
, TRUNC(SYSDATE))
AND PRA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRA.BUSINESS_GROUP_ID)
AND PRA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PRA.RECRUITING_SITE_ID = IRST.RECRUITING_SITE_ID(+)
AND IRST.LANGUAGE(+) = USERENV('LANG') WITH READ ONLY