APPS.BEN_PEN_BUS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1203: from ben_elig_per_elctbl_chc

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

Line 1275: from ben_elig_per_elctbl_chc

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

Line 1622: ben_elig_per_elctbl_chc epe,

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

Line 2509: from ben_elig_per_elctbl_chc

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