APPS.BEN_PDP_BUS dependencies on BEN_PER_IN_LER

Line 303: ,ben_per_in_ler pil

299: --
300: cursor c3 is
301: select null
302: from ben_elig_cvrd_dpnt_f ecd
303: ,ben_per_in_ler pil
304: where ecd.dpnt_person_id = p_dpnt_person_id
305: and ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
306: and ecd.elig_cvrd_dpnt_id <> nvl(p_elig_cvrd_dpnt_id, hr_api.g_number)
307: and ecd.business_group_id = p_business_group_id

Line 911: FROM ben_per_in_ler pil

907: --
908: CURSOR c_lf_evt_ocrd_dt
909: IS
910: SELECT lf_evt_ocrd_dt
911: FROM ben_per_in_ler pil
912: WHERE pil.per_in_ler_id = rslt_per_in_ler_id;
913: --
914: CURSOR c_crt_ordr
915: IS

Line 1023: FROM ben_elig_cvrd_dpnt_f pdp, ben_per_in_ler pil

1019: --
1020: CURSOR c_elig_dpnt
1021: IS
1022: SELECT NULL
1023: FROM ben_elig_cvrd_dpnt_f pdp, ben_per_in_ler pil
1024: WHERE pdp.dpnt_person_id = l_dpnt_id
1025: AND pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1026: AND p_effective_date BETWEEN pdp.effective_start_date
1027: AND pdp.effective_end_date

Line 1290: from ben_per_in_ler

1286: Return VARCHAR2 is
1287: --
1288: cursor c_leod is
1289: select lf_evt_ocrd_dt
1290: from ben_per_in_ler
1291: where per_in_ler_id = p_per_in_ler_id;
1292: --
1293: cursor c_crt_ordr(p_lf_evt_ocrd_dt date) is
1294: select 'Y'