DBA Data[Home] [Help]

APPS.CSICUMPI_PUB dependencies on HZ_CUST_ACCOUNTS

Line 9: FROM hz_cust_accounts hzacct,

5: p_org_id NUMBER) RETURN VARCHAR2 IS
6:
7: CURSOR c1(l_account_number VARCHAR2) is
8: SELECT hzpty.party_name
9: FROM hz_cust_accounts hzacct,
10: hz_cust_account_roles hzrole,
11: hz_parties hzpty
12: WHERE hzacct.account_number = l_account_number
13: AND hzrole.cust_account_id = hzacct.cust_account_id