APPS.HZ_CUST_ACCT_SITE_BO_PUB dependencies on HZ_PARTIES

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 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