APPS.EGO_DATA_SECURITY dependencies on HZ_RELATIONSHIPS

Line 78: FROM hz_relationships group_membership_rel

74: FUNCTION get_group_info (p_party_id IN NUMBER) RETURN VARCHAR2 IS
75:
76: CURSOR group_membership_c (cp_orig_system_id IN NUMBER) IS
77: SELECT 'HZ_GROUP:'||group_membership_rel.object_id group_name
78: FROM hz_relationships group_membership_rel
79: WHERE group_membership_rel.RELATIONSHIP_CODE = 'MEMBER_OF'
80: AND group_membership_rel.status= 'A'
81: AND group_membership_rel.start_date <= SYSDATE
82: AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE

Line 111: FROM hz_relationships group_membership_rel

107:
108: FUNCTION get_company_info (p_party_id IN NUMBER) RETURN VARCHAR2 IS
109: CURSOR company_membership_c (cp_orig_system_id IN NUMBER) IS
110: SELECT 'HZ_COMPANY:'||group_membership_rel.object_id company_name
111: FROM hz_relationships group_membership_rel
112: WHERE group_membership_rel.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
113: AND group_membership_rel.status= 'A'
114: AND group_membership_rel.start_date <= SYSDATE
115: AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE