VIEW: APPS.HR_SUP_BASE_V

Source

View Text - Preformatted

SELECT distinct full_name, last_name , first_name , order_name , to_char(person_id) person_id, to_char(business_group_id) business_group_id, effective_start_date , effective_end_date , decode (hr_security.view_all, 'Y', 'TRUE' ,HR_SECURITY.SHOW_RECORD ('PER_ALL_PEOPLE_F',person_id, person_type_id, employee_number, applicant_number)) inside_profile from per_all_people_f WHERE (current_employee_flag = 'Y' or current_npw_flag = 'Y' and nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y')

View Text - HTML Formatted

SELECT DISTINCT FULL_NAME
, LAST_NAME
, FIRST_NAME
, ORDER_NAME
, TO_CHAR(PERSON_ID) PERSON_ID
, TO_CHAR(BUSINESS_GROUP_ID) BUSINESS_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DECODE (HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD ('PER_ALL_PEOPLE_F'
, PERSON_ID
, PERSON_TYPE_ID
, EMPLOYEE_NUMBER
, APPLICANT_NUMBER)) INSIDE_PROFILE
FROM PER_ALL_PEOPLE_F
WHERE (CURRENT_EMPLOYEE_FLAG = 'Y' OR CURRENT_NPW_FLAG = 'Y'
AND NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N') = 'Y')