DBA Data[Home] [Help]

APPS.OZF_UTILITY_PVT dependencies on HZ_CUST_ACCOUNTS

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

3148: RETURN VARCHAR2
3149: IS
3150: CURSOR c_party_name(p_cust_account_id NUMBER)
3151: IS
3152: SELECT hp.party_name FROM hz_parties hp , hz_cust_accounts hca
3153: WHERE hca.party_id = hp.party_id
3154: AND hca.status = 'A'
3155: AND hca.cust_account_id = p_cust_account_id;
3156: l_party_name hz_parties.party_name%type;