APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_CBR_QUALD_BNF

Line 10109: l_object_version_number ben_cbr_quald_bnf.object_version_number%TYPE;

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

Line 10114: l_cbr_elig_perd_end_dt ben_cbr_quald_bnf.cbr_elig_perd_end_dt%TYPE;

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

Line 10122: FROM ben_cbr_quald_bnf cqb

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

Line 10217: FROM ben_cbr_quald_bnf cqb

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

Line 10270: FROM ben_cbr_quald_bnf cqb

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

Line 10515: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

10511: -- person is no longer a COBRA qualified beneficiary.
10512: --
10513: l_object_version_number := l_cqb_rec.object_version_number;
10514: --
10515: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
10516: (p_cbr_quald_bnf_id=> l_cqb_rec.cbr_quald_bnf_id
10517: ,p_quald_bnf_flag => 'N'
10518: ,p_business_group_id => p_business_group_id
10519: ,p_object_version_number => l_object_version_number