APPS.POS_DATA_SECURITY dependencies on HZ_RELATIONSHIPS

Line 27: FROM hz_relationships group_membership_rel

23: FUNCTION get_group_info (p_party_id IN NUMBER) RETURN VARCHAR2 IS
24:
25: CURSOR group_membership_c (cp_orig_system_id IN NUMBER) IS
26: SELECT 'HZ_GROUP:'||group_membership_rel.object_id group_name
27: FROM hz_relationships group_membership_rel
28: WHERE group_membership_rel.RELATIONSHIP_CODE = 'MEMBER_OF'
29: AND group_membership_rel.status= 'A'
30: AND group_membership_rel.start_date <= SYSDATE
31: AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE

Line 60: FROM hz_relationships group_membership_rel

56:
57: FUNCTION get_company_info (p_party_id IN NUMBER) RETURN VARCHAR2 IS
58: CURSOR company_membership_c (cp_orig_system_id IN NUMBER) IS
59: SELECT 'HZ_COMPANY:'||group_membership_rel.object_id company_name
60: FROM hz_relationships group_membership_rel
61: WHERE group_membership_rel.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
62: AND group_membership_rel.status = 'A'
63: AND group_membership_rel.start_date <= SYSDATE
64: AND NVL(group_membership_rel.end_date, SYSDATE) >= SYSDATE