APPS.BEN_PDP_BUS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 302: from ben_elig_cvrd_dpnt_f ecd

298: l_exists_2 varchar2(1);
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)

Line 351: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK1');

347: --
348: -- raise error as FK does not relate to PK in per_all_people
349: -- table.
350: --
351: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK1');
352: --
353: end if;
354: --
355: close c1;

Line 456: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');

452: --
453: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
454: -- table.
455: --
456: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');
457: --
458: end if;
459: --
460: close c1;

Line 615: from ben_elig_cvrd_dpnt_f

611: -- total number of covered dependents for the result
612: --
613: cursor total_num_dpnt_c is
614: select count(elig_cvrd_dpnt_id)
615: from ben_elig_cvrd_dpnt_f
616: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
617: and cvg_strt_dt is not null
618: and cvg_thru_dt = hr_api.g_eot
619: -- and cvrd_flag = 'Y'

Line 634: , ben_elig_cvrd_dpnt_f d

630:
631: cursor rlshp_num_dpnt_c is
632: select count(*)
633: from per_contact_relationships c
634: , ben_elig_cvrd_dpnt_f d
635: where
636: c.person_id = l_person_id
637: and c.contact_person_id = d.dpnt_person_id
638: and d.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 692: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');

688: --
689: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
690: -- table.
691: --
692: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');
693: --
694: else
695: --
696: --

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 1827: ben_elig_cvrd_dpnt_f b

1823: --
1824: cursor csr_leg_code is
1825: select a.legislation_code
1826: from per_business_groups a,
1827: ben_elig_cvrd_dpnt_f b
1828: where b.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1829: and a.business_group_id = b.business_group_id;
1830: --
1831: -- Declare local variables