APPS.PAY_LOAD_PARAMETERS dependencies on PER_BUSINESS_GROUPS

Line 127: per_business_groups pbg

123: cursor pp_exits(p_parameter_name varchar2) is
124: select pp.parameter_id
125: from pay_parameters pp,
126: pay_parameter_definitions ppd,
127: per_business_groups pbg
128: where ppd.parameter_name = p_parameter_name
129: AND ppd.parameter_def_id = pp.parameter_def_id
130: AND pp.business_group_id = pbg.business_group_id(+)
131: and nvl(pbg.name,'CORE') = nvl(p_bg_name,'CORE')

Line 157: from per_business_groups

153: --
154: if (p_bg_name is not null) then
155: select business_group_id
156: into l_business_group_id
157: from per_business_groups
158: where name = p_bg_name;
159: end if;
160: --
161: if(found = TRUE) then