APPS.EGO_GROUP_WF_PKG dependencies on HZ_RELATIONSHIPS

Line 291: -- FROM fnd_user users, hz_parties parties, hz_relationships grp_owner

287: WHERE party_id = p_party_id;
288:
289: -- CURSOR get_owner_user_party_names_c (p_group_id NUMBER) IS
290: -- SELECT users.user_name, parties.party_name
291: -- FROM fnd_user users, hz_parties parties, hz_relationships grp_owner
292: -- WHERE grp_owner.object_id = p_group_id
293: -- AND grp_owner.relationship_type = G_OWNER_GROUP_REL_TYPE
294: -- AND grp_owner.status = 'A'
295: -- AND SYSDATE BETWEEN grp_owner.start_date

Line 303: FROM hz_relationships

299:
300:
301: CURSOR get_group_member_rel_id_c (p_group_id NUMBER, p_member_id NUMBER) IS
302: SELECT relationship_id
303: FROM hz_relationships
304: WHERE subject_id = p_member_id
305: AND object_id = p_group_id
306: AND status = 'A'
307: AND relationship_type = G_MEMBER_GROUP_REL_TYPE

Line 953: -- ,hz_relationships grp_owner

949: -- CURSOR c_get_owner_name(cp_group_id NUMBER) IS
950: -- SELECT users.user_name
951: -- FROM fnd_user users
952: -- ,hz_parties parties
953: -- ,hz_relationships grp_owner
954: -- WHERE users.customer_id = parties.party_id
955: -- AND parties.party_id = grp_owner.subject_id
956: -- WHERE users.customer_id = grp_owner.subject_id
957: -- AND grp_owner.relationship_type = G_OWNER_GROUP_REL_TYPE

Line 1490: FROM hz_relationships

1486: l_object_version_number NUMBER;
1487:
1488: CURSOR c_get_object_ver_no (cp_relationship_id IN NUMBER) IS
1489: SELECT object_version_number
1490: FROM hz_relationships
1491: WHERE relationship_id = cp_relationship_id;
1492:
1493: BEGIN
1494:

Line 1821: -- FROM hz_parties grp, hz_relationships grp_owner

1817: -- group name is not unique in APPS
1818: --
1819: -- CURSOR c_get_ownerid(cp_group_name VARCHAR2) IS
1820: -- SELECT grp_owner.subject_id
1821: -- FROM hz_parties grp, hz_relationships grp_owner
1822: -- WHERE grp.party_name = cp_group_name
1823: -- AND grp.application_id = EGO_PARTY_PUB.get_application_id
1824: -- AND grp.party_type = 'GROUP'
1825: -- AND grp_owner.object_id = grp.party_id