[Home] [Help]
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
Name |
PERSON_ID |
FULL_NAME |
EMPLOYEE_NUMBER |
LAST_NAME |
FIRST_NAME |
MIDDLE_NAMES |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
BUSINESS_GROUP_ID |
ACTIVE |