APPS.BEN_EXT_ELIG_DPNT dependencies on BEN_EXTRACT

Line 335: if ben_extract.g_eda_csr = 'Y' then

331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;
332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;
333: --
334: -- retrieve dependent address info if required
335: if ben_extract.g_eda_csr = 'Y' then
336: open prim_address_c (l_dpel_dpnt_person_id_va(i));
337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1
338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3

Line 363: if ben_extract.g_edp_csr = 'Y' then

359: close prim_address_c;
360: end if;
361: --
362: -- retrieve dependent phone numbers if required
363: if ben_extract.g_edp_csr = 'Y' then
364: open ext_phone_c(l_dpel_dpnt_person_id_va(i));
365: fetch ext_phone_c into ben_ext_person.g_elig_dpnt_home_phone
366: ,ben_ext_person.g_elig_dpnt_work_phone
367: ,ben_ext_person.g_elig_dpnt_fax