View: PER_LETTER_REQ_LINES_LOV

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_LETTER_REQ_LINES_LOV

View Text

SELECT ASS.ASSIGNMENT_STATUS_TYPE_ID
, PP.FULL_NAME
, PP.ORDER_NAME
, PP.EMPLOYEE_NUMBER
, PP.APPLICANT_NUMBER
, PP.NPW_NUMBER
, HR_PERSON_TYPE_USAGE_INFO.GET_USER_PERSON_TYPE(PP.EFFECTIVE_START_DATE
, PP.PERSON_ID) USER_PERSON_TYPE
, ASS.ASSIGNMENT_ID
, PP.PERSON_ID
, ORGTL.NAME
, GRP.GROUP_NAME
, JBT.NAME
, PFT.NAME
, GDT.NAME
, HR_GENERAL.DECODE_LOCATION(ASS.LOCATION_ID)
, ASS.BUSINESS_GROUP_ID + 0
, ASS.VACANCY_ID
FROM PER_ASSIGNMENTS ASS
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, PAY_PEOPLE_GROUPS GRP
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, PER_ALL_PEOPLE PP
WHERE ASS.PERSON_ID = PP.PERSON_ID
AND ASS.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ASS.PEOPLE_GROUP_ID = GRP.PEOPLE_GROUP_ID (+)
AND ASS.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND ASS.POSITION_ID = PFT.POSITION_ID (+)
AND PFT.LANGUAGE(+) = USERENV('LANG')
AND ASS.GRADE_ID = GDT.GRADE_ID (+)
AND GDT.LANGUAGE(+) = USERENV('LANG')
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND ORGTL.LANGUAGE = USERENV('LANG')

Columns