DBA Data[Home] [Help]

APPS.BEN_EPE_BUS dependencies on PER_BUSINESS_GROUPS

Line 1634: ,per_business_groups pbg

1630: --
1631: cursor c1 is
1632: select null
1633: from ff_formulas_f ff
1634: ,per_business_groups pbg
1635: where ff.formula_id = p_enrt_cvg_strt_dt_rl
1636: and ff.formula_type_id = -29
1637: and pbg.business_group_id = p_business_group_id
1638: and nvl(ff.business_group_id, p_business_group_id) =

Line 1729: ,per_business_groups pbg

1725: --
1726: cursor c1 is
1727: select null
1728: from ff_formulas_f ff
1729: ,per_business_groups pbg
1730: where ff.formula_id = p_dpnt_cvg_strt_dt_rl
1731: and ff.formula_type_id = -27
1732: and pbg.business_group_id = p_business_group_id
1733: and nvl(ff.business_group_id, p_business_group_id) =

Line 1814: from per_business_groups a,

1810: -- Declare cursor
1811: --
1812: cursor csr_leg_code is
1813: select a.legislation_code
1814: from per_business_groups a,
1815: ben_elig_per_elctbl_chc b
1816: where b.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1817: and a.business_group_id = b.business_group_id;
1818: --