VIEW: APPS.CSM_PER_ALL_PEOPLE_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.PERSON_ID , B.EFFECTIVE_START_DATE , B.EFFECTIVE_END_DATE , B.LAST_NAME , B.START_DATE , B.DATE_OF_BIRTH , B.EMAIL_ADDRESS , B.EMPLOYEE_NUMBER , B.FIRST_NAME , B.FULL_NAME , B.MIDDLE_NAMES , B.NATIONALITY , B.SEX , B.TITLE , B.WORK_TELEPHONE , B.PARTY_ID FROM CSM_PER_ALL_PEOPLE_ACC ACC , PER_ALL_PEOPLE_F B WHERE ACC.PERSON_ID = B.PERSON_ID AND ACC.EFFECTIVE_START_DATE = B.EFFECTIVE_START_DATE AND ACC.EFFECTIVE_END_DATE = B.EFFECTIVE_END_DATE AND ACC.USER_ID = ASG_BASE.GET_USER_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.PERSON_ID
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.LAST_NAME
, B.START_DATE
, B.DATE_OF_BIRTH
, B.EMAIL_ADDRESS
, B.EMPLOYEE_NUMBER
, B.FIRST_NAME
, B.FULL_NAME
, B.MIDDLE_NAMES
, B.NATIONALITY
, B.SEX
, B.TITLE
, B.WORK_TELEPHONE
, B.PARTY_ID
FROM CSM_PER_ALL_PEOPLE_ACC ACC
, PER_ALL_PEOPLE_F B
WHERE ACC.PERSON_ID = B.PERSON_ID
AND ACC.EFFECTIVE_START_DATE = B.EFFECTIVE_START_DATE
AND ACC.EFFECTIVE_END_DATE = B.EFFECTIVE_END_DATE
AND ACC.USER_ID = ASG_BASE.GET_USER_ID