APPS.JTF_CAL_WF_PVT dependencies on HZ_CONTACT_POINTS

Line 17: l_email_address hz_contact_points.EMAIL_ADDRESS%type;

13: IS
14:
15: l_employee_number NUMBER;
16: l_name varchar2(320);
17: l_email_address hz_contact_points.EMAIL_ADDRESS%type;
18:
19: CURSOR c_resource
20: ( b_resourceID NUMBER
21: )IS SELECT source_id EmployeeNumber

Line 30: hz_contact_points hc

26: CURSOR c_contact_detail (b_resource_id NUMBER ) IS
27: select pers.PARTY_name , hc.email_ADDRESS
28: from hz_parties pers,
29: hz_relationships hr,
30: hz_contact_points hc
31: where hc.owner_table_id = b_resource_id
32: and hr.party_id = hc.owner_table_id
33: and hr.subject_id = pers.party_id
34: and hr.subject_type = 'PERSON'