VIEW: APPS.WF_PER_ROLE_ROLES

Source

View Text - Preformatted

SELECT /*+ index_ffs(PER,PER_PEOPLE_F_PK)
 */ 'PER_ROLE:'||PER.PERSON_ID, PER.FULL_NAME, PER.FULL_NAME, 'MAILHTML',
 NULL, NULL, PER.EMAIL_ADDRESS, NULL, 'PER_ROLE', PER.PERSON_ID,
 PER.EFFECTIVE_START_DATE, 'ACTIVE', PER.EFFECTIVE_END_DATE, NULL, 'N', 3
 from PER_ALL_PEOPLE_F PER where trunc(SYSDATE) between
 PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE

   

View Text - HTML Formatted

SELECT /*+ INDEX_FFS(PER
, PER_PEOPLE_F_PK) */ 'PER_ROLE:'||PER.PERSON_ID
, PER.FULL_NAME
, PER.FULL_NAME
, 'MAILHTML'
, NULL
, NULL
, PER.EMAIL_ADDRESS
, NULL
, 'PER_ROLE'
, PER.PERSON_ID
, PER.EFFECTIVE_START_DATE
, 'ACTIVE'
, PER.EFFECTIVE_END_DATE
, NULL
, 'N'
, 3
FROM PER_ALL_PEOPLE_F PER
WHERE TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE