APPS.BEN_EXT_ENRT_SPCL dependencies on BEN_EXTRACT

Line 479: if ben_extract.g_pgn_csr = 'Y' then

475:
476: -- retrieve additional enrollment information
477: --
478: -- retrieve policy or group number if required
479: if ben_extract.g_pgn_csr = 'Y' then
480:
481: open c_prtt_asg ;
482: fetch c_prtt_asg into l_prtt_asg_id ;
483: close c_prtt_asg ;

Line 492: if ben_extract.g_ppcp_csr = 'Y' then

488: end if;
489: --
490: -- retrieve primary care provider info if required
491: --
492: if ben_extract.g_ppcp_csr = 'Y' then
493: open c_dpnt_prmry_care_prvdr(dpnt_enrt.elig_cvrd_dpnt_id);
494: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_ppr_name
495: ,ben_ext_person.g_ppr_ident
496: ,ben_ext_person.g_ppr_typ

Line 503: IF ben_extract.g_enrt_lvl = 'Y' THEN

499: close c_dpnt_prmry_care_prvdr;
500: end if;
501: --
502: --
503: IF ben_extract.g_enrt_lvl = 'Y' THEN
504: --
505: -- format and write enrollment
506: -- ===========================
507: --