VIEW: APPS.PER_QUICKPAINT_ASSIGNMENTS

Source

View Text - Preformatted

SELECT A.ASSIGNMENT_ID , A.PERSON_ID , A.BUSINESS_GROUP_ID , A.ORGANIZATION_ID , OTL.NAME , P.FULL_NAME , TTL.PERSON_TYPE_ID /* , TTL.USER_PERSON_TYPE */ , hr_person_type_usage_info.get_user_person_type(p.effective_end_date,p.person_id) , A.ASSIGNMENT_NUMBER FROM PER_ALL_ASSIGNMENTS A , PER_PEOPLE P , PER_PERSON_TYPES_TL TTL , HR_ALL_ORGANIZATION_UNITS_TL OTL WHERE A.PERSON_ID = P.PERSON_ID AND P.PERSON_TYPE_ID = TTL.PERSON_TYPE_ID AND A.ORGANIZATION_ID = OTL.organization_id AND OTL.language = userenv('LANG') AND TTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT A.ASSIGNMENT_ID
, A.PERSON_ID
, A.BUSINESS_GROUP_ID
, A.ORGANIZATION_ID
, OTL.NAME
, P.FULL_NAME
, TTL.PERSON_TYPE_ID /*
, TTL.USER_PERSON_TYPE */
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(P.EFFECTIVE_END_DATE
, P.PERSON_ID)
, A.ASSIGNMENT_NUMBER
FROM PER_ALL_ASSIGNMENTS A
, PER_PEOPLE P
, PER_PERSON_TYPES_TL TTL
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE A.PERSON_ID = P.PERSON_ID
AND P.PERSON_TYPE_ID = TTL.PERSON_TYPE_ID
AND A.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND TTL.LANGUAGE = USERENV('LANG')