VIEW: APPS.BIS_HR_BUDGETS_V

Source

View Text - Preformatted

SELECT DISTINCT TO_CHAR(g.business_group_id)||'+'||TO_CHAR(b.budget_id) ID ,b.name VALUE ,g.business_group_id BUSINESS_GROUP_ID ,g.name BUSINESS_GROUP_NAME ,b.budget_id BUDGET_ID ,b.name BUDGET_NAME from per_business_groups g ,per_budgets b ,per_budget_versions v WHERE b.business_group_id = g.business_group_id and b.budget_id = v.budget_id and trunc(sysdate) between v.date_from and nvl(v.date_to,sysdate)

View Text - HTML Formatted

SELECT DISTINCT TO_CHAR(G.BUSINESS_GROUP_ID)||'+'||TO_CHAR(B.BUDGET_ID) ID
, B.NAME VALUE
, G.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, G.NAME BUSINESS_GROUP_NAME
, B.BUDGET_ID BUDGET_ID
, B.NAME BUDGET_NAME
FROM PER_BUSINESS_GROUPS G
, PER_BUDGETS B
, PER_BUDGET_VERSIONS V
WHERE B.BUSINESS_GROUP_ID = G.BUSINESS_GROUP_ID
AND B.BUDGET_ID = V.BUDGET_ID
AND TRUNC(SYSDATE) BETWEEN V.DATE_FROM
AND NVL(V.DATE_TO
, SYSDATE)