DBA Data[Home] [Help]

APPS.CSICUMPI_PUB dependencies on HZ_PARTIES

Line 11: hz_parties hzpty

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
14: AND hzpty.party_id = hzrole.party_id;
15: