APPS.OZF_UTILITY_PVT dependencies on HZ_PARTIES

Line 904: FROM hz_parties

900: WHERE fund_id = p_object_id;
901:
902: CURSOR c_partner (p_object_id IN NUMBER) IS
903: SELECT party_name
904: FROM hz_parties
905: WHERE party_id = p_object_id;
906: BEGIN
907:
908: l_object_name := NULL;

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;

Line 3156: l_party_name hz_parties.party_name%type;

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;
3157: BEGIN
3158: OPEN c_party_name(p_cust_account_id );
3159: FETCH c_party_name INTO l_party_name;
3160: CLOSE c_party_name;