DBA Data[Home] [Help]

APPS.OKC_REP_SIGN_WF_PVT dependencies on HZ_RELATIONSHIPS

Line 357: hz_relationships hr,

353: AND pvc.vendor_contact_id=p_contact_id;
354:
355: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS
356: SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
357: hz_relationships hr,
358: hz_parties hz,
359: FND_USER f
360: WHERE
361: hr.party_id = p_contact_id