Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_DEFAULT_PROFILES_V |
SELECT PROFILE.PROFILE_ID
, PROFILE.PROFILE_NAME
, PROFILE.BUSINESS_GROUP_ID
, BG.NAME
, PROFILE.ORGANIZATION_ID
, HR.NAME
, PROFILE.JOB_ID
, PJ.NAME
, PER.POSITION_ID
, PER.NAME
, LOOKUP.LOOKUP_CODE
, LOOKUP.MEANING
, PROFILE.DESCRIPTION
, PROFILE.EFFECTIVE_START_DATE
, PROFILE.EFFECTIVE_END_DATE
FROM PA_ROLE_PROFILES PROFILE
, PER_BUSINESS_GROUPS BG
, HR_ORGANIZATION_UNITS HR
, PER_POSITIONS PER
, PER_JOBS PJ
, PA_LOOKUPS LOOKUP
WHERE PROFILE.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID (+)
AND PROFILE.ORGANIZATION_ID = HR.ORGANIZATION_ID (+)
AND PROFILE.JOB_ID = PJ.JOB_ID (+)
AND PROFILE.POSITION_ID = PER.POSITION_ID (+)
AND PROFILE.PROFILE_TYPE_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'PA_ROLE_PROFILE_TYPE'
AND RESOURCE_ID IS NULL