DBA Data[Home] [Help]

APPS.BEN_BENXSMRY_XMLP_PKG dependencies on PER_BUSINESS_GROUPS

Line 13: FROM per_business_groups

9: function business_groupformula(p_business_group_id in number) return varchar2 is
10:
11: cursor get_bg_name is
12: SELECT name
13: FROM per_business_groups
14: WHERE business_group_id = p_business_group_id;
15:
16: l_name per_business_groups.name%type ;
17: begin

Line 16: l_name per_business_groups.name%type ;

12: SELECT name
13: FROM per_business_groups
14: WHERE business_group_id = p_business_group_id;
15:
16: l_name per_business_groups.name%type ;
17: begin
18: open get_bg_name;
19: fetch get_bg_name into l_name;
20: close get_bg_name;