DBA Data[Home] [Help]

APPS.BEN_ADE_BUS dependencies on PER_BUSINESS_GROUPS

Line 288: ,per_business_groups pbg

284: --
285: cursor c1 is
286: select null
287: from ff_formulas_f ff
288: ,per_business_groups pbg
289: where ff.formula_id = p_apld_dpnt_cvg_elig_rl
290: and ff.formula_type_id = -35
291: and pbg.business_group_id = p_business_group_id
292: and nvl(ff.business_group_id, p_business_group_id) =

Line 742: from per_business_groups a,

738: -- Declare cursor
739: --
740: cursor csr_leg_code is
741: select a.legislation_code
742: from per_business_groups a,
743: ben_apld_dpnt_cvg_elig_prfl_f b
744: where b.apld_dpnt_cvg_elig_prfl_id = p_apld_dpnt_cvg_elig_prfl_id
745: and a.business_group_id = b.business_group_id;
746: --