View: IGW_PERSONS_V

Product:	IGW - Grants Proposal
Description:	10SC Only
Implementation/DBA Data:	APPS.IGW_PERSONS_V

View Text

SELECT P.PERSON_ID
, P.FULL_NAME
, P.EMPLOYEE_NUMBER
, P.LAST_NAME
, P.FIRST_NAME
, P.MIDDLE_NAMES
, P.EFFECTIVE_START_DATE
, P.EFFECTIVE_END_DATE
, P.BUSINESS_GROUP_ID
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, '*'
, P.CURRENT_EMPLOYEE_FLAG) "ACTIVE"
FROM IGW_IMPLEMENTATIONS IMP
, PER_PEOPLE_F P
WHERE IMP.BUSINESS_GROUP_ID = P.BUSINESS_GROUP_ID + 0
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND P.EMPLOYEE_NUMBER IS NOT NULL

Columns