715: --
716: -- Bug Fix 3261422 Start
717: cursor csr_get_party_id is
718: select party_id 719: from per_all_people_f per 720: where per.person_id = p_person_id
721: and trunc(p_effective_date)
722: between per.effective_start_date
723: and per.effective_end_date;