442: --
443: cursor get_contacts_pils(cv_person_id in number,
444: cv_csd_by_ptnl_ler_for_per_id in number) is
445: select pil.*
446: from per_contact_relationships pcr,
447: ben_per_in_ler pil,
448: ben_PTNL_LER_FOR_PER ppl
449: where --pcr.contact_person_id = cv_person_id
450: pcr.person_id = cv_person_id -- Bug 6620291
467:
468: cursor get_fut_dtd_cntct_pils(cv_person_id in number
469: ) is
470: select pil.*
471: from per_contact_relationships pcr,
472: ben_per_in_ler pil,
473: ben_PTNL_LER_FOR_PER ppl
474: where pcr.contact_person_id = cv_person_id
475: and pcr.business_group_id = p_business_group_id
485: cursor get_contacts_ptnls(cv_person_id in number,
486: cv_csd_by_ptnl_ler_for_per_id in number) is
487: select con_ppl.*
488: from ben_ptnl_ler_for_per con_ppl,
489: per_contact_relationships pcr
490: where con_ppl.csd_by_ptnl_ler_for_per_id = cv_csd_by_ptnl_ler_for_per_id
491: and con_ppl.PERSON_ID = pcr.person_id
492: and con_ppl.ptnl_ler_for_per_src_cd in ('SYSGND')
493: and pcr.contact_person_id = p_person_id;