APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_CBR_QUALD_BNF

Line 10108: l_object_version_number ben_cbr_quald_bnf.object_version_number%TYPE;

10104: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
10105: l_dys_no_enrl_not_elig_num ben_lee_rsn_f.dys_no_enrl_not_elig_num%TYPE;
10106: l_rec ben_person_object.g_person_date_info_rec;
10107: l_per_in_ler_id ben_per_in_ler.per_in_ler_id%TYPE;
10108: l_object_version_number ben_cbr_quald_bnf.object_version_number%TYPE;
10109: l_effective_date DATE;
10110: l_due_date DATE;
10111: l_eff_due_date DATE;
10112: l_elcns_made_dt DATE;

Line 10113: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;

10109: l_effective_date DATE;
10110: l_due_date DATE;
10111: l_eff_due_date DATE;
10112: l_elcns_made_dt DATE;
10113: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;
10114: l_init_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%TYPE;
10115: l_ler_id ben_per_in_ler.ler_id%TYPE;
10116: --
10117: CURSOR c_get_cbr_elig_dates IS

Line 10121: FROM ben_cbr_quald_bnf cqb

10117: CURSOR c_get_cbr_elig_dates IS
10118: SELECT cqb.*
10119: ,crp.per_in_ler_id
10120: ,pil.ler_id
10121: FROM ben_cbr_quald_bnf cqb
10122: ,ben_cbr_per_in_ler crp
10123: ,ben_per_in_ler pil
10124: WHERE cqb.quald_bnf_person_id = p_person_id
10125: AND cqb.quald_bnf_flag = 'Y'

Line 10216: FROM ben_cbr_quald_bnf cqb

10212: p_cvrd_emp_person_id IN NUMBER
10213: ,p_pgm_id IN NUMBER
10214: ,p_ptip_id IN NUMBER) IS
10215: SELECT cqb.*
10216: FROM ben_cbr_quald_bnf cqb
10217: ,ben_cbr_per_in_ler crp
10218: ,ben_per_in_ler pil
10219: WHERE cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
10220: AND cqb.quald_bnf_flag = 'Y'

Line 10269: FROM ben_cbr_quald_bnf cqb

10265: ,cqb.pgm_id
10266: ,cqb.ptip_id
10267: ,crp.per_in_ler_id
10268: ,pil.ler_id
10269: FROM ben_cbr_quald_bnf cqb
10270: ,ben_cbr_per_in_ler crp
10271: ,ben_per_in_ler pil
10272: WHERE cqb.quald_bnf_person_id = p_person_id
10273: AND cqb.quald_bnf_flag = 'Y'

Line 10495: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

10491: -- person is no longer a COBRA qualified beneficiary.
10492: --
10493: l_object_version_number := l_cqb_rec.object_version_number;
10494: --
10495: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
10496: (p_cbr_quald_bnf_id=> l_cqb_rec.cbr_quald_bnf_id
10497: ,p_quald_bnf_flag => 'N'
10498: ,p_business_group_id => p_business_group_id
10499: ,p_object_version_number => l_object_version_number