APPS.BEN_EPA_BUS dependencies on BEN_PRTN_ELIG_F

Line 1352: from ben_prtn_elig_f

1348: l_exists varchar2(1);
1349: --
1350: cursor c1 is
1351: select null
1352: from ben_prtn_elig_f
1353: where pgm_id = p_pgm_id
1354: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1355: and business_group_id + 0 = p_business_group_id
1356: and p_validation_start_date <= effective_end_date

Line 1436: from ben_prtn_elig_f

1432: l_exists varchar2(1);
1433: --
1434: cursor c1 is
1435: select null
1436: from ben_prtn_elig_f
1437: where pl_id = p_pl_id
1438: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1439: and business_group_id + 0 = p_business_group_id
1440: and p_validation_start_date <= effective_end_date

Line 1520: from ben_prtn_elig_f

1516: l_exists varchar2(1);
1517: --
1518: cursor c1 is
1519: select null
1520: from ben_prtn_elig_f
1521: where oipl_id = p_oipl_id
1522: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1523: and business_group_id + 0 = p_business_group_id
1524: and p_validation_start_date <= effective_end_date

Line 1604: from ben_prtn_elig_f

1600: l_exists varchar2(1);
1601: --
1602: cursor c1 is
1603: select null
1604: from ben_prtn_elig_f
1605: where ptip_id = p_ptip_id
1606: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1607: and business_group_id+0 = p_business_group_id
1608: and p_validation_start_date <= effective_end_date

Line 1690: from ben_prtn_elig_f

1686: l_exists varchar2(1);
1687: --
1688: cursor c1 is
1689: select null
1690: from ben_prtn_elig_f
1691: where plip_id = p_plip_id
1692: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1693: and business_group_id+0 = p_business_group_id
1694: and p_validation_start_date <= effective_end_date

Line 2420: ben_prtn_elig_f b

2416: --
2417: cursor csr_leg_code is
2418: select a.legislation_code
2419: from per_business_groups a,
2420: ben_prtn_elig_f b
2421: where b.prtn_elig_id = p_prtn_elig_id
2422: and a.business_group_id = b.business_group_id;
2423: --
2424: -- Declare local variables