APPS.OTA_LEARNER_ENROLL_SS dependencies on HZ_PARTIES

Line 156: HZ_PARTIES party,

152: ACCT_ROLE.cust_account_role_id CONTACT_ID,
153: ACCT_ROLE.cust_account_id CUSTOMER_ID
154:
155: from HZ_CUST_ACCOUNT_ROLES acct_role,
156: HZ_PARTIES party,
157: HZ_RELATIONSHIPS rel,
158: HZ_ORG_CONTACTS org_cont,
159: HZ_PARTIES rel_party,
160: HZ_CUST_ACCOUNTS role_acct

Line 159: HZ_PARTIES rel_party,

155: from HZ_CUST_ACCOUNT_ROLES acct_role,
156: HZ_PARTIES party,
157: HZ_RELATIONSHIPS rel,
158: HZ_ORG_CONTACTS org_cont,
159: HZ_PARTIES rel_party,
160: HZ_CUST_ACCOUNTS role_acct
161:
162: where acct_role.party_id = rel.party_id
163: and acct_role.role_type = 'CONTACT'

Line 167: and rel.subject_table_name = 'HZ_PARTIES'

163: and acct_role.role_type = 'CONTACT'
164: and org_cont.party_relationship_id = rel.relationship_id
165: and rel.subject_id = party.party_id
166: and rel.party_id = rel_party.party_id
167: and rel.subject_table_name = 'HZ_PARTIES'
168: and rel.object_table_name = 'HZ_PARTIES'
169: and acct_role.cust_account_id = role_acct.cust_account_id
170: and role_acct.party_id = rel.object_id
171: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;

Line 168: and rel.object_table_name = 'HZ_PARTIES'

164: and org_cont.party_relationship_id = rel.relationship_id
165: and rel.subject_id = party.party_id
166: and rel.party_id = rel_party.party_id
167: and rel.subject_table_name = 'HZ_PARTIES'
168: and rel.object_table_name = 'HZ_PARTIES'
169: and acct_role.cust_account_id = role_acct.cust_account_id
170: and role_acct.party_id = rel.object_id
171: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
172: