APPS.IEX_DUNNING_PVT dependencies on HZ_RELATIONSHIPS

Line 126: from HZ_RELATIONSHIPS rel,

122: rel.party_id,
123: rel.subject_id,
124: point.contact_point_id,
125: rel.relationship_type
126: from HZ_RELATIONSHIPS rel,
127: hz_contact_points point
128: where rel.object_id = P_PARTY_ID and
129: rel.relationship_type in ('DUNNING', 'COLLECTIONS') and
130: rel.status = 'A' and

Line 146: from HZ_RELATIONSHIPS rel

142: decode(P_REL_TYPE, rel.relationship_type, 1, 2) Display_Order,
143: rel.party_id,
144: rel.subject_id,
145: rel.relationship_type
146: from HZ_RELATIONSHIPS rel
147: where rel.object_id = P_PARTY_ID and
148: rel.relationship_type in ('DUNNING', 'COLLECTIONS') and
149: rel.status = 'A'
150: order by Display_Order;

Line 367: HZ_RELATIONSHIPS rel,

363: from
364: HZ_CUST_SITE_USES_ALL site_use,
365: HZ_CUST_ACCOUNT_ROLES acct_role,
366: HZ_ROLE_RESPONSIBILITY role_resp,
367: HZ_RELATIONSHIPS rel,
368: hz_parties party,
369: hz_parties sub_party
370: where
371: site_use.site_use_id = P_SITE_USE_ID and

Line 688: HZ_RELATIONSHIPS rel,

684: rel.object_id
685: from
686: HZ_CUST_ACCOUNT_ROLES acct_role,
687: HZ_ROLE_RESPONSIBILITY role_resp,
688: HZ_RELATIONSHIPS rel,
689: hz_parties party,
690: hz_parties sub_party
691: where
692: acct_role.cust_account_id = P_CUST_ACCOUNT_ID and

Line 7675: FROM HZ_RELATIONSHIPS

7671: WHERE party_ID = in_party_ID;
7672: --
7673: CURSOR C_GET_DUNNING_ORG (IN_PARTY_ID NUMBER) IS
7674: SELECT party_id
7675: FROM HZ_RELATIONSHIPS
7676: WHERE object_id = in_party_ID
7677: AND relationship_type = 'DUNNING'
7678: AND status = 'A';
7679: --

Line 7682: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r

7678: AND status = 'A';
7679: --
7680: CURSOR C_GET_ORG_PARTY (IN_REL_PARTY_ID NUMBER) IS
7681: SELECT r.object_id --org party id
7682: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
7683: WHERE r.party_id = in_rel_party_ID
7684: AND p.party_id = r.object_id
7685: AND p.party_type = 'ORGANIZATION';
7686: --