APPS.BEN_BENXAUDT_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 18: FROM hr_all_organization_units_vl

14: --function business_nameformula(business_group_id in number) return varchar2 is
15: function business_nameformula(p_business_group_id in number) return varchar2 is
16: cursor get_bg is
17: SELECT name
18: FROM hr_all_organization_units_vl
19: --WHERE organization_id = business_group_id;
20: WHERE organization_id = p_business_group_id;
21: l_bg_name hr_all_organization_units.name%type;
22: begin

Line 21: l_bg_name hr_all_organization_units.name%type;

17: SELECT name
18: FROM hr_all_organization_units_vl
19: --WHERE organization_id = business_group_id;
20: WHERE organization_id = p_business_group_id;
21: l_bg_name hr_all_organization_units.name%type;
22: begin
23:
24: open get_bg;
25: fetch get_bg into l_bg_name;