VIEW: APPS.HRI_CL_PER_APL_BX_V

Source

View Text - Preformatted

SELECT per.person_id ID , per.full_name VALUE , per.effective_start_date date_from , per.effective_end_date date_to , per.business_group_id business_group_id , CASE WHEN(per.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,per.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_people_x per, per_person_types ppt WHERE per.person_type_id = ppt.person_type_id AND ppt.system_person_type in ('EMP_APL','APL') UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time date_from , hr_general.end_of_time date_to , -1 business_group_id , 'Y' bg_security_flag_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PER.PERSON_ID ID
, PER.FULL_NAME VALUE
, PER.EFFECTIVE_START_DATE DATE_FROM
, PER.EFFECTIVE_END_DATE DATE_TO
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN(PER.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PER.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_PEOPLE_X PER
, PER_PERSON_TYPES PPT
WHERE PER.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
AND PPT.SYSTEM_PERSON_TYPE IN ('EMP_APL'
, 'APL') UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 BUSINESS_GROUP_ID
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY