DBA Data[Home] [Help]

APPS.JTF_RS_IMP_RES_PVT dependencies on HZ_ORG_CONTACTS

Line 276: hz_org_contacts hzoc

272: CURSOR party_contact_cur(l_party_id IN NUMBER)
273: IS
274: SELECT hzoc.org_contact_id CONTACT_ID
275: FROM hz_relationships hzr,
276: hz_org_contacts hzoc
277: WHERE hzr.party_id = l_party_id
278: AND hzr.directional_flag = 'F'
279: AND hzr.relationship_code = 'EMPLOYEE_OF'
280: AND hzr.subject_table_name ='HZ_PARTIES'