APPS.HRI_DBI_WMV_BUDGET dependencies on HR_ORGANIZATION_INFORMATION

Line 33: FROM hr_organization_information org,

29: ,budget_version_id
30: ,budgeted_count)
31: SELECT DISTINCT org.org_information2, b.version_date_from, b.version_date_to,
32: b.budget_version_id,0
33: FROM hr_organization_information org,
34: hri_mb_budget_v b
35: WHERE org.org_information_context = 'Organization Name Alias'
36: AND org.org_information2 IS NOT NULL
37: AND org.organization_id = b.organization_id

Line 59: HR_ORGANIZATION_INFORMATION org

55: SET hrp.budgeted_count = (SELECT sum(decode(g_abv_type,b.budget_unit1_system_type_cd, b.budget_unit1_value,
56: b.budget_unit2_system_type_cd, b.budget_unit2_value,
57: b.budget_unit1_system_type_cd,b.budget_unit3_value ))
58: FROM HRI_MB_BUDGET_V b,
59: HR_ORGANIZATION_INFORMATION org
60: WHERE b.position_control_flag_code = 'Y'
61: AND b.organization_id = org.organization_id
62: AND org.org_information_context = 'Organization Name Alias'
63: AND org.org_information2 = hrp.supervisor_id