DBA Data[Home] [Help]

APPS.BEN_WCN_BUS dependencies on PER_BUSINESS_GROUPS

Line 187: ,per_business_groups pbg

183: --
184: cursor c1 is
185: select null
186: from ff_formulas_f ff
187: ,per_business_groups pbg
188: where ff.formula_id = p_ctfn_rqd_when_rl
189: and ff.formula_type_id = -502
190: and pbg.business_group_id = p_business_group_id
191: and nvl(ff.business_group_id, p_business_group_id) =

Line 818: from per_business_groups a,

814: -- Declare cursor
815: --
816: cursor csr_leg_code is
817: select a.legislation_code
818: from per_business_groups a,
819: ben_wv_prtn_rsn_ctfn_pl_f b
820: where b.wv_prtn_rsn_ctfn_pl_id = p_wv_prtn_rsn_ctfn_pl_id
821: and a.business_group_id = b.business_group_id;
822: --