APPS.BEN_EXT_DPNT dependencies on BEN_EXTRACT

Line 351: if ben_extract.g_da_csr = 'Y' then

347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;
348: -- end if ;
349: --
350: -- retrieve dependent address info if required
351: if ben_extract.g_da_csr = 'Y' then
352: open prim_address_c(dpnt.dpnt_person_id);
353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1
354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3

Line 379: if ben_extract.g_dp_csr = 'Y' then

375: close prim_address_c;
376: end if;
377: --
378: -- retrieve dependent phone numbers if required
379: if ben_extract.g_dp_csr = 'Y' then
380: open ext_phone_c(dpnt.dpnt_person_id);
381: fetch ext_phone_c into ben_ext_person.g_dpnt_home_phone
382: ,ben_ext_person.g_dpnt_work_phone
383: ,ben_ext_person.g_dpnt_fax

Line 389: if ben_extract.g_dpcp_csr = 'Y' then

385: close ext_phone_c;
386: end if;
387: --
388: -- retrieve dependent primary care provider info if required
389: if ben_extract.g_dpcp_csr = 'Y' then
390: open c_dpnt_prmry_care_prvdr(dpnt.elig_cvrd_dpnt_id);
391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name
392: ,ben_ext_person.g_dpnt_ppr_ident
393: ,ben_ext_person.g_dpnt_ppr_typ