APPS.OTA_LEARNER_ENROLL_SS dependencies on HZ_PARTIES

Line 155: HZ_PARTIES party,

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

Line 158: HZ_PARTIES rel_party,

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

Line 166: and rel.subject_table_name = 'HZ_PARTIES'

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

Line 167: and rel.object_table_name = 'HZ_PARTIES'

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