DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_COBRA_REQUIREMENTS

Line 9543: ben_cobra_requirements.get_amount_due

9539: --
9540: -- Fetch Amount Due
9541: --
9542:
9543: ben_cobra_requirements.get_amount_due
9544: (p_person_id => p_person_id
9545: ,p_business_group_id => p_business_group_id
9546: ,p_assignment_id => p_assignment_id
9547: ,p_payroll_id => p_payroll_id

Line 10496: ben_cobra_requirements.chk_enrld_or_cvrd(p_pgm_id=> l_cqb_rec.pgm_id

10492: -- hr_utility.set_location('effective_date ' ||l_effective_date,10);
10493: IF LEAST(SYSDATE
10494: ,l_effective_date) > l_end_elig_date THEN
10495: IF (
10496: ben_cobra_requirements.chk_enrld_or_cvrd(p_pgm_id=> l_cqb_rec.pgm_id
10497: ,p_ptip_id => l_cqb_rec.ptip_id
10498: ,p_person_id => p_person_id
10499: ,p_effective_date => p_effective_date
10500: ,p_business_group_id => p_business_group_id

Line 10572: IF ben_cobra_requirements.chk_dsbld(p_person_id=> l_cqb2_rec.quald_bnf_person_id

10568: --
10569: FOR l_cqb2_rec IN c_get_all_quald_bnf(l_cqb_rec.cvrd_emp_person_id
10570: ,l_cqb_rec.pgm_id
10571: ,l_cqb_rec.ptip_id) LOOP
10572: IF ben_cobra_requirements.chk_dsbld(p_person_id=> l_cqb2_rec.quald_bnf_person_id
10573: ,p_lf_evt_ocrd_dt => l_effective_date
10574: ,p_effective_date => p_effective_date
10575: ,p_business_group_id => p_business_group_id) = TRUE THEN
10576: --

Line 10581: ben_cobra_requirements.get_lf_evt_ocrd_dt(p_per_in_ler_id=> l_cqb_rec.per_in_ler_id

10577: -- Check if person was disabled at the time of the initial
10578: -- qualifying event.
10579: --
10580: l_init_lf_evt_ocrd_dt :=
10581: ben_cobra_requirements.get_lf_evt_ocrd_dt(p_per_in_ler_id=> l_cqb_rec.per_in_ler_id
10582: ,p_business_group_id => p_business_group_id);
10583: --
10584: IF ben_cobra_requirements.chk_dsbld(p_person_id=> l_cqb2_rec.quald_bnf_person_id
10585: ,p_lf_evt_ocrd_dt => l_init_lf_evt_ocrd_dt

Line 10584: IF ben_cobra_requirements.chk_dsbld(p_person_id=> l_cqb2_rec.quald_bnf_person_id

10580: l_init_lf_evt_ocrd_dt :=
10581: ben_cobra_requirements.get_lf_evt_ocrd_dt(p_per_in_ler_id=> l_cqb_rec.per_in_ler_id
10582: ,p_business_group_id => p_business_group_id);
10583: --
10584: IF ben_cobra_requirements.chk_dsbld(p_person_id=> l_cqb2_rec.quald_bnf_person_id
10585: ,p_lf_evt_ocrd_dt => l_init_lf_evt_ocrd_dt
10586: ,p_effective_date => p_effective_date
10587: ,p_business_group_id => p_business_group_id) = TRUE THEN
10588: --

Line 10601: ben_cobra_requirements.get_cbr_elig_end_dt(p_cbr_elig_perd_strt_dt=> l_cqb_rec.cbr_elig_perd_strt_dt

10597: l_dsbld := TRUE;
10598: --
10599: CLOSE c_get_max_poe;
10600: l_cbr_elig_perd_end_dt :=
10601: ben_cobra_requirements.get_cbr_elig_end_dt(p_cbr_elig_perd_strt_dt=> l_cqb_rec.cbr_elig_perd_strt_dt
10602: ,p_person_id => p_person_id
10603: --RCHASE pass pl typ id
10604: ,p_pl_typ_id => l_cqb_rec.pl_typ_id
10605: --RCHASE end