APPS.OZF_UTILITY_PVT dependencies on HZ_PARTIES

Line 887: FROM hz_parties

883: WHERE fund_id = p_object_id;
884:
885: CURSOR c_partner (p_object_id IN NUMBER) IS
886: SELECT party_name
887: FROM hz_parties
888: WHERE party_id = p_object_id;
889: BEGIN
890:
891: l_object_name := NULL;

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;

Line 3134: l_party_name hz_parties.party_name%type;

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;
3135: BEGIN
3136: OPEN c_party_name(p_cust_account_id );
3137: FETCH c_party_name INTO l_party_name;
3138: CLOSE c_party_name;