DBA Data[Home] [Help]

VIEW: APPS.HRBV_CAREER_PATHS_V

Source

View Text - Preformatted

SELECT PCP.NAME, PCP.COMMENTS, PCP.PROGRAM_UPDATE_DATE, '_DF:PER:PER_CAREER_PATHS:PCP', PCP.CAREER_PATH_ID, PCP.BUSINESS_GROUP_ID, PCP.LAST_UPDATE_DATE, PCP.LAST_UPDATED_BY, PCP.CREATED_BY, PCP.CREATION_DATE, CASE WHEN PCP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PCP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_CAREER_PATHS PCP WITH READ ONLY
View Text - HTML Formatted

SELECT PCP.NAME
, PCP.COMMENTS
, PCP.PROGRAM_UPDATE_DATE
, '_DF:PER:PER_CAREER_PATHS:PCP'
, PCP.CAREER_PATH_ID
, PCP.BUSINESS_GROUP_ID
, PCP.LAST_UPDATE_DATE
, PCP.LAST_UPDATED_BY
, PCP.CREATED_BY
, PCP.CREATION_DATE
, CASE WHEN PCP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCP.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_CAREER_PATHS PCP WITH READ ONLY