VIEW: APPS.PA_PEOPLE_ROLE_ON_ORGS_V

Source

View Text - Preformatted

SELECT PPRT.PROJECT_ROLE_ID, PPRT.PROJECT_ROLE_TYPE, PPRT.MEANING, FG.INSTANCE_PK1_VALUE, HAOU.NAME, PE.PERSON_ID, PE.FULL_NAME PARTY_NAME, FG.START_DATE, FG.END_DATE from PA_PROJECT_ROLE_TYPES PPRT, PER_PEOPLE_F PE, HR_ALL_ORGANIZATION_UNITS HAOU, fnd_grants fg, fnd_objects fo WHERE PPRT.Menu_id = fg.menu_id AND fo.obj_name = 'ORGANIZATION' AND fg.object_id = fo.object_id AND fg.instance_type = 'INSTANCE' AND fg.grantee_type ='USER' AND substr(fg.grantee_key,instr(fg.grantee_key,':')+1) = PE.PARTY_ID AND HAOU.ORGANIZATION_ID = instance_pk1_value AND FG.START_DATE between trunc(PE.EFFECTIVE_START_DATE) and trunc(PE.EFFECTIVE_END_DATE)

View Text - HTML Formatted

SELECT PPRT.PROJECT_ROLE_ID
, PPRT.PROJECT_ROLE_TYPE
, PPRT.MEANING
, FG.INSTANCE_PK1_VALUE
, HAOU.NAME
, PE.PERSON_ID
, PE.FULL_NAME PARTY_NAME
, FG.START_DATE
, FG.END_DATE
FROM PA_PROJECT_ROLE_TYPES PPRT
, PER_PEOPLE_F PE
, HR_ALL_ORGANIZATION_UNITS HAOU
, FND_GRANTS FG
, FND_OBJECTS FO
WHERE PPRT.MENU_ID = FG.MENU_ID
AND FO.OBJ_NAME = 'ORGANIZATION'
AND FG.OBJECT_ID = FO.OBJECT_ID
AND FG.INSTANCE_TYPE = 'INSTANCE'
AND FG.GRANTEE_TYPE ='USER'
AND SUBSTR(FG.GRANTEE_KEY
, INSTR(FG.GRANTEE_KEY
, ':')+1) = PE.PARTY_ID
AND HAOU.ORGANIZATION_ID = INSTANCE_PK1_VALUE
AND FG.START_DATE BETWEEN TRUNC(PE.EFFECTIVE_START_DATE)
AND TRUNC(PE.EFFECTIVE_END_DATE)