APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 37: --| HZ_CUST_ACCT_RELATE_ALL | X | | | | | |

33: --| JTF_NOTES_VL | X | | | | | |
34: --+---------------------------------+---+---+---+---+---+----------------------+
35: --| HZ_PARTIES | X | | | | | |
36: --+---------------------------------+---+---+---+---+---+----------------------+
37: --| HZ_CUST_ACCT_RELATE_ALL | X | | | | | |
38: --+---------------------------------+---+---+---+---+---+----------------------+
39: --| DUAL | X | | | | | |
40: --+---------------------------------+---+---+---+---+---+----------------------+
41: --| OKC_K_GROUPS_B | X | | | | | |

Line 1322: FROM hz_cust_acct_relate_all a,

1318: hz_parties party1
1319: WHERE ca2.party_id = party1.party_id
1320: AND ca2.cust_account_id IN (
1321: SELECT a.related_cust_account_id
1322: FROM hz_cust_acct_relate_all a,
1323: hz_cust_accounts b
1324: WHERE b.cust_account_id = a.cust_account_id
1325: AND b.party_id = p_party_id
1326: AND b.status = 'A'

Line 1682: , HZ_CUST_ACCT_RELATE_ALL A

1678: UNION
1679:
1680: SELECT 'Y'
1681: FROM HZ_CUST_ACCOUNTS CA2
1682: , HZ_CUST_ACCT_RELATE_ALL A
1683: , HZ_CUST_ACCOUNTS B
1684: WHERE CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
1685: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
1686: And Ca2.cust_account_id = p_account_id