VIEW: APPS.HRBV_BUDGET_ELEMENTS_V

Source

View Text - Preformatted

SELECT PDE.BUDGET_ELEMENT_ID, PDE.BUSINESS_GROUP_ID, PDE.GRADE_ID, PDE.JOB_ID, PDE.POSITION_ID, PDE.ORGANIZATION_ID, PDE.BUDGET_VERSION_ID, PDE.TRAINING_PLAN_ID, PDE.TRAINING_PLAN_MEMBER_ID, PDE.EVENT_ID, PDE.LAST_UPDATE_DATE, PDE.LAST_UPDATED_BY, PDE.CREATED_BY, PDE.CREATION_DATE, CASE WHEN PDE.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PDE.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_BUDGET_ELEMENTS PDE WITH READ ONLY

View Text - HTML Formatted

SELECT PDE.BUDGET_ELEMENT_ID
, PDE.BUSINESS_GROUP_ID
, PDE.GRADE_ID
, PDE.JOB_ID
, PDE.POSITION_ID
, PDE.ORGANIZATION_ID
, PDE.BUDGET_VERSION_ID
, PDE.TRAINING_PLAN_ID
, PDE.TRAINING_PLAN_MEMBER_ID
, PDE.EVENT_ID
, PDE.LAST_UPDATE_DATE
, PDE.LAST_UPDATED_BY
, PDE.CREATED_BY
, PDE.CREATION_DATE
, CASE WHEN PDE.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PDE.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_BUDGET_ELEMENTS PDE WITH READ ONLY