APPS.BEN_EXT_BNF dependencies on BEN_EXTRACT

Line 305: if ben_extract.g_ba_csr = 'Y' then

301: hr_utility.set_location('Beneficiary id ' || bnfcry.bnf_person_id,178);
302: --
303: -- retrieve beneficiary address if required
304: l_relatated_true := 'N' ;
305: if ben_extract.g_ba_csr = 'Y' then
306: open prim_address_c(bnfcry.bnf_person_id);
307: fetch prim_address_c into ben_ext_person.g_bnf_prim_address1
308: , ben_ext_person.g_bnf_prim_address2
309: , ben_ext_person.g_bnf_prim_address3

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

331: end if;
332: --
333: -- retrieve beneficiary phone numbers if required
334:
335: if ben_extract.g_bp_csr = 'Y' then
336: if l_relatated_true = 'N' then
337: open ext_phone_c(bnfcry.bnf_person_id);
338: fetch ext_phone_c into ben_ext_person.g_bnf_home_phone
339: , ben_ext_person.g_bnf_work_phone