APPS.JTF_CAL_WF_PVT dependencies on HZ_PARTIES

Line 28: from hz_parties pers,

24: ;
25:
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

Line 38: and hc.owner_table_name = 'HZ_PARTIES';

34: and hr.subject_type = 'PERSON'
35: and hc.primary_flag = 'Y'
36: and hc.contact_point_type = 'EMAIL'
37: AND hc.status ='A'
38: and hc.owner_table_name = 'HZ_PARTIES';
39:
40: BEGIN
41: ---------------------------------------------------------------------
42: -- Get the employee number

Line 59: --HZ_PARTIES should be populated in the workflow directory

55: x_name := NULL;*/
56: --get employee number so adhoc user can be associated with the resource
57: x_emp_number := NULL;
58: BEGIN
59: --HZ_PARTIES should be populated in the workflow directory
60: WF_DIRECTORY.GetRoleName( p_orig_system => 'HZ_PARTY'
61: , p_orig_system_id => p_resource_id
62: , p_name => x_role
63: , p_display_name => x_name