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 236: , per_business_groups_perf bg

232: --
233: cursor csr_unique_check(p_mode varchar2) is
234: select bt.balance_type_id
235: from pay_balance_types bt
236: , per_business_groups_perf bg
237: where ((p_mode = 'BALANCE_NAME'
238: and upper(bt.balance_name) = upper(translate(p_balance_name,'_',' ')))
239: or (p_mode = 'REPORTING_NAME'
240: and upper(bt.reporting_name) = upper(translate(p_reporting_name,'_',' ')))

Line 259: from per_business_groups

255: and chartorowid(p_row_id) <> bt.rowid));
256: --
257: cursor csr_bg_leg_code is
258: select legislation_code
259: from per_business_groups
260: where business_group_id = p_business_group_id;
261: --
262: begin
263: --