DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on HZ_CUST_ACCOUNTS

Line 3130: SELECT hp.party_name FROM hz_parties hp , hz_cust_accounts hca

3126: RETURN VARCHAR2
3127: IS
3128: CURSOR c_party_name(p_cust_account_id NUMBER)
3129: IS
3130: SELECT hp.party_name FROM hz_parties hp , hz_cust_accounts hca
3131: WHERE hca.party_id = hp.party_id
3132: AND hca.status = 'A'
3133: AND hca.cust_account_id = p_cust_account_id;
3134: l_party_name hz_parties.party_name%type;