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 373: HZ_RELATIONSHIPS rel,

369: from
370: HZ_CUST_SITE_USES_ALL site_use,
371: HZ_CUST_ACCOUNT_ROLES acct_role,
372: HZ_ROLE_RESPONSIBILITY role_resp,
373: HZ_RELATIONSHIPS rel,
374: hz_parties party,
375: hz_parties sub_party
376: where
377: site_use.site_use_id = P_SITE_USE_ID and

Line 692: HZ_RELATIONSHIPS rel,

688: rel.object_id
689: from
690: HZ_CUST_ACCOUNT_ROLES acct_role,
691: HZ_ROLE_RESPONSIBILITY role_resp,
692: HZ_RELATIONSHIPS rel,
693: hz_parties party,
694: hz_parties sub_party
695: where
696: acct_role.cust_account_id = P_CUST_ACCOUNT_ID and

Line 15186: FROM HZ_RELATIONSHIPS

15182: WHERE party_ID = in_party_ID;
15183: --
15184: CURSOR C_GET_DUNNING_ORG (IN_PARTY_ID NUMBER) IS
15185: SELECT party_id
15186: FROM HZ_RELATIONSHIPS
15187: WHERE object_id = in_party_ID
15188: AND relationship_type = 'DUNNING'
15189: AND status = 'A';
15190: --

Line 15193: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r

15189: AND status = 'A';
15190: --
15191: CURSOR C_GET_ORG_PARTY (IN_REL_PARTY_ID NUMBER) IS
15192: SELECT r.object_id --org party id
15193: FROM HZ_PARTIES p, HZ_RELATIONSHIPS r
15194: WHERE r.party_id = in_rel_party_ID
15195: AND p.party_id = r.object_id
15196: AND p.party_type = 'ORGANIZATION';
15197: --