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 1318: FROM hz_cust_acct_relate_all a,

1314: hz_parties party1
1315: WHERE ca2.party_id = party1.party_id
1316: AND ca2.cust_account_id IN (
1317: SELECT a.related_cust_account_id
1318: FROM hz_cust_acct_relate_all a,
1319: hz_cust_accounts b
1320: WHERE b.cust_account_id = a.cust_account_id
1321: AND b.party_id = p_party_id
1322: AND b.status = 'A'

Line 1678: , HZ_CUST_ACCT_RELATE_ALL A

1674: UNION
1675:
1676: SELECT 'Y'
1677: FROM HZ_CUST_ACCOUNTS CA2
1678: , HZ_CUST_ACCT_RELATE_ALL A
1679: , HZ_CUST_ACCOUNTS B
1680: WHERE CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
1681: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
1682: And Ca2.cust_account_id = p_account_id