2448: AND party_role_code = p_party_role_code
2449: AND contact_id = p_contact_id
2450: AND contact_role_id = p_contact_role_id;
2451:
2452: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.
2453:
2454: CURSOR internal_party_contact_csr IS
2455: SELECT 1
2456: FROM per_workforce_v
2452: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.
2453:
2454: CURSOR internal_party_contact_csr IS
2455: SELECT 1
2456: FROM per_workforce_v
2457: WHERE person_id = p_contact_id
2458: AND full_name = p_contact_name;
2459:
2460: CURSOR tca_party_contact_csr IS