APPS.OTA_TDB_BUS dependencies on HZ_PARTIES

Line 468: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

464: HZ_CUST_ACCOUNTS ROLE_ACCT
465:
466: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
467: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
468: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
469: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
470: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
471: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
472: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_person_id;

Line 469: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

465:
466: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
467: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
468: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
469: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
470: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
471: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
472: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_person_id;
473:

Line 1814: HZ_PARTIES party,

1810: /* bug 3463908 */
1811: Cursor c_party is
1812: SELECT party.party_id
1813: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
1814: HZ_PARTIES party,
1815: HZ_RELATIONSHIPS rel,
1816: HZ_ORG_CONTACTS org_cont,
1817: HZ_PARTIES rel_party,
1818: HZ_CUST_ACCOUNTS role_acct

Line 1817: HZ_PARTIES rel_party,

1813: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
1814: HZ_PARTIES party,
1815: HZ_RELATIONSHIPS rel,
1816: HZ_ORG_CONTACTS org_cont,
1817: HZ_PARTIES rel_party,
1818: HZ_CUST_ACCOUNTS role_acct
1819: WHERE acct_role.party_id = rel.party_id
1820: AND acct_role.role_type = 'CONTACT'
1821: AND org_cont.party_relationship_id = rel.relationship_id

Line 1824: AND rel.subject_table_name = 'HZ_PARTIES'

1820: AND acct_role.role_type = 'CONTACT'
1821: AND org_cont.party_relationship_id = rel.relationship_id
1822: AND rel.subject_id = party.party_id
1823: AND rel.party_id = rel_party.party_id
1824: AND rel.subject_table_name = 'HZ_PARTIES'
1825: AND rel.object_table_name = 'HZ_PARTIES'
1826: AND acct_role.cust_account_id = role_acct.cust_account_id
1827: AND role_acct.party_id = rel.object_id
1828: AND ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;

Line 1825: AND rel.object_table_name = 'HZ_PARTIES'

1821: AND org_cont.party_relationship_id = rel.relationship_id
1822: AND rel.subject_id = party.party_id
1823: AND rel.party_id = rel_party.party_id
1824: AND rel.subject_table_name = 'HZ_PARTIES'
1825: AND rel.object_table_name = 'HZ_PARTIES'
1826: AND acct_role.cust_account_id = role_acct.cust_account_id
1827: AND role_acct.party_id = rel.object_id
1828: AND ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
1829: /* bug 3463908 */