APPS.BEN_EXT_CONTACT dependencies on BEN_EXTRACT

Line 324: if ben_extract.g_coa_csr = 'Y' then

320: ben_ext_person.g_contact_start_ler_id := contact.start_life_reason_id;
321: ben_ext_person.g_contact_end_ler_id := contact.end_life_reason_id;
322: --
323: -- retrieve dependent address info if required
324: if ben_extract.g_coa_csr = 'Y' then
325: open prim_address_c (contact.contact_person_id);
326: fetch prim_address_c into ben_ext_person.g_contact_prim_address1
327: ,ben_ext_person.g_contact_prim_address2
328: ,ben_ext_person.g_contact_prim_address3

Line 352: if ben_extract.g_cop_csr = 'Y' then

348: close prim_address_c;
349: end if;
350: --
351: -- retrieve dependent phone numbers if required
352: if ben_extract.g_cop_csr = 'Y' then
353: open ext_phone_c(contact.contact_person_id);
354: fetch ext_phone_c into ben_ext_person.g_contact_home_phone
355: ,ben_ext_person.g_contact_work_phone
356: ,ben_ext_person.g_contact_fax

Line 362: if ben_extract.g_coed_csr = 'Y' then

358: close ext_phone_c;
359: end if;
360:
361: -- retrieve eligible dependent flag
362: if ben_extract.g_coed_csr = 'Y' then
363: ben_ext_person.g_contact_is_elig_dpnt_flag := 'N';
364: open c_elig_dpnt(contact.contact_person_id);
365: fetch c_elig_dpnt into ben_ext_person.g_contact_is_elig_dpnt_flag;
366: close c_elig_dpnt;

Line 370: if ben_extract.g_cocd_csr = 'Y' then

366: close c_elig_dpnt;
367: end if;
368:
369: -- retrieve covered dependent flag
370: if ben_extract.g_cocd_csr = 'Y' then
371: ben_ext_person.g_contact_is_cvrd_dpnt_flag := 'N';
372: open c_cvrd_dpnt(contact.contact_person_id);
373: fetch c_cvrd_dpnt into ben_ext_person.g_contact_is_cvrd_dpnt_flag;
374: close c_cvrd_dpnt;

Line 378: if ben_extract.g_cob_csr = 'Y' then

374: close c_cvrd_dpnt;
375: end if;
376:
377: -- retrieve beneficiary flag
378: if ben_extract.g_cob_csr = 'Y' then
379: ben_ext_person.g_contact_is_bnfcry_flag := 'N';
380: open c_beneficiary(contact.contact_person_id);
381: fetch c_beneficiary into ben_ext_person.g_contact_is_bnfcry_flag;
382: close c_beneficiary;

Line 386: if ben_extract.g_cosl_csr = 'Y' then

382: close c_beneficiary;
383: end if;
384: --
385: -- retrieve life reason start
386: if ben_extract.g_cosl_csr = 'Y' then
387: open c_start_ler(contact.start_life_reason_id);
388: fetch c_start_ler into ben_ext_person.g_contact_start_life_evt;
389: close c_start_ler;
390: end if;

Line 393: if ben_extract.g_coel_csr = 'Y' then

389: close c_start_ler;
390: end if;
391: --
392: -- retrieve life reason end
393: if ben_extract.g_coel_csr = 'Y' then
394: open c_end_ler(contact.end_life_reason_id);
395: fetch c_end_ler into ben_ext_person.g_contact_end_life_evt;
396: close c_end_ler;
397: end if;