APPS.BEN_PEN_BUS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1202: from ben_elig_per_elctbl_chc

1198: l_step integer;
1199: -- 3427367
1200: cursor c_epe is
1201: select elig_per_elctbl_chc_id
1202: from ben_elig_per_elctbl_chc
1203: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1204: --
1205: l_jurisdiction_code varchar2(30);
1206: l_elig_per_elctbl_chc_id number;

Line 1274: from ben_elig_per_elctbl_chc

1270: l_step integer;
1271: -- 3427367
1272: cursor c_epe is
1273: select elig_per_elctbl_chc_id
1274: from ben_elig_per_elctbl_chc
1275: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1276: --
1277: l_jurisdiction_code varchar2(30);
1278: l_elig_per_elctbl_chc_id number;

Line 1621: ben_elig_per_elctbl_chc epe,

1617: epe.MUST_ENRL_ANTHR_PL_ID,
1618: 'N' dpnt_cvd_by_othr_apls_flag,
1619: -9999999999999999999999999999999999999 opt_id
1620: from ben_prtt_enrt_rslt_f pen,
1621: ben_elig_per_elctbl_chc epe,
1622: ben_plip_f cpp,
1623: ben_oipl_f cop,
1624: ben_pl_f pln
1625: where pen.person_id = c_person_id

Line 2508: from ben_elig_per_elctbl_chc

2504: ,p_effective_date Date
2505: ) is
2506: Cursor c1 is
2507: select null
2508: from ben_elig_per_elctbl_chc
2509: where business_group_id = p_business_group_id
2510: and nvl(pgm_id,hr_api.g_number) = nvl(p_pgm_id, hr_api.g_number)
2511: and MNDTRY_FLAG = 'Y'
2512: and pl_id in -- bug 1207161 removed 'not'