DBA Data[Home] [Help]

APPS.BEN_LOP_BUS dependencies on PER_BUSINESS_GROUPS

Line 397: per_business_groups pbg

393: --
394: cursor c1 is
395: select null
396: from ff_formulas_f ff,
397: per_business_groups pbg
398: where ff.formula_id = p_dflt_enrt_rl
399: and ff.formula_type_id = - 32
400: and pbg.business_group_id = p_business_group_id
401: and nvl(ff.business_group_id, p_business_group_id) =

Line 562: per_business_groups pbg

558: --
559: cursor c1 is
560: select null
561: from ff_formulas_f ff,
562: per_business_groups pbg
563: where ff.formula_id = p_enrt_rl
564: and ff.formula_type_id = - 393
565: and pbg.business_group_id = p_business_group_id
566: and nvl(ff.business_group_id, p_business_group_id) =

Line 658: per_business_groups pbg

654: --
655: cursor c1 is
656: select null
657: from ff_formulas_f ff,
658: per_business_groups pbg
659: where ff.formula_id = p_auto_enrt_mthd_rl
660: and ff.formula_type_id = - 146
661: and pbg.business_group_id = p_business_group_id
662: and nvl(ff.business_group_id, p_business_group_id) =

Line 1481: from per_business_groups a,

1477: -- Declare cursor
1478: --
1479: cursor csr_leg_code is
1480: select a.legislation_code
1481: from per_business_groups a,
1482: ben_ler_chg_oipl_enrt_f b
1483: where b.ler_chg_oipl_enrt_id = p_ler_chg_oipl_enrt_id
1484: and a.business_group_id = b.business_group_id;
1485: --