DBA Data[Home] [Help]

APPS.BEN_LPR_BUS dependencies on PER_BUSINESS_GROUPS

Line 493: per_business_groups pbg

489: --
490: cursor c1 is
491: select null
492: from ff_formulas_f ff,
493: per_business_groups pbg
494: where ff.formula_id = p_enrt_rl
495: and ff.formula_type_id = - 393
496: and pbg.business_group_id = p_business_group_id
497: and nvl(ff.business_group_id, p_business_group_id) =

Line 588: per_business_groups pbg

584: --
585: cursor c1 is
586: select null
587: from ff_formulas_f ff,
588: per_business_groups pbg
589: where ff.formula_id = p_dflt_enrt_rl
590: and ff.formula_type_id = - 32
591: and pbg.business_group_id = p_business_group_id
592: and nvl(ff.business_group_id, p_business_group_id) =

Line 936: per_business_groups pbg

932: --
933: cursor c1 is
934: select null
935: from ff_formulas_f ff,
936: per_business_groups pbg
937: where ff.formula_id = p_auto_enrt_mthd_rl
938: and ff.formula_type_id = - 146
939: and pbg.business_group_id = p_business_group_id
940: and nvl(ff.business_group_id, p_business_group_id) =

Line 1467: from per_business_groups a,

1463: -- Declare cursor
1464: --
1465: cursor csr_leg_code is
1466: select a.legislation_code
1467: from per_business_groups a,
1468: ben_ler_chg_plip_enrt_f b
1469: where b.ler_chg_plip_enrt_id = p_ler_chg_plip_enrt_id
1470: and a.business_group_id = b.business_group_id;
1471: --