APPS.PAY_BALANCE_TYPES_PKG dependencies on PER_BUSINESS_GROUPS

Line 144: from per_business_groups pbg

140: --
141: cursor get_legislation(p_bg_id number)
142: is
143: select pbg.legislation_code
144: from per_business_groups pbg
145: where pbg.business_group_id = p_bg_id;
146: --
147: cursor get_leg_rule(p_leg_code varchar2)
148: is

Line 231: , per_business_groups_perf bg

227: --
228: cursor csr_unique_check(p_mode varchar2) is
229: select bt.balance_type_id
230: from pay_balance_types bt
231: , per_business_groups_perf bg
232: where ((p_mode = 'BALANCE_NAME'
233: and upper(bt.balance_name) = upper(translate(p_balance_name,'_',' ')))
234: or (p_mode = 'REPORTING_NAME'
235: and upper(bt.reporting_name) = upper(translate(p_reporting_name,'_',' ')))

Line 254: from per_business_groups

250: and chartorowid(p_row_id) <> bt.rowid));
251: --
252: cursor csr_bg_leg_code is
253: select legislation_code
254: from per_business_groups
255: where business_group_id = p_business_group_id;
256: --
257: begin
258: --