APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_CUST_ACCOUNTS

Line 182: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS a

178: l_cbm VARCHAR2(30);
179:
180: CURSOR get_acct_party(l_acct_id NUMBER) IS
181: SELECT p.party_id, decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON')
182: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS a
183: WHERE p.party_id = a.party_id
184: AND a.cust_account_id = l_acct_id;
185:
186: CURSOR get_ps_id(l_os VARCHAR2, l_osr VARCHAR2) IS

Line 1254: Customer account site Y N HZ_CUST_ACCOUNTS

1250: for the particular contact from these TCA entity tables.
1251:
1252: Embedded TCA Entity Mandatory Multiple TCA Table Entities
1253:
1254: Customer account site Y N HZ_CUST_ACCOUNTS
1255: Bank account site Use N Y Owned by Payments team
1256: Payment Method N N Owned by AR team
1257:
1258: */

Line 1619: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS a

1615: l_cbm VARCHAR2(30);
1616:
1617: CURSOR get_acct_party(l_acct_id NUMBER) IS
1618: SELECT p.party_id, decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON')
1619: FROM HZ_PARTIES p, HZ_CUST_ACCOUNTS a
1620: WHERE p.party_id = a.party_id
1621: AND a.cust_account_id = l_acct_id;
1622:
1623: CURSOR get_ps_id(l_os VARCHAR2, l_osr VARCHAR2) IS

Line 2562: Customer account site Y N HZ_CUST_ACCOUNTS

2558: for the particular contact from these TCA entity tables.
2559:
2560: Embedded TCA Entity Mandatory Multiple TCA Table Entities
2561:
2562: Customer account site Y N HZ_CUST_ACCOUNTS
2563: Bank account site Use N Y Owned by Payments team
2564: Payment Method N N Owned by AR team
2565:
2566: */