214: l_return_status VARCHAR2(1);
215:
216: CURSOR C_Party_Exists (X_Party_Id NUMBER) IS
217: SELECT 1 218: FROM HZ_PARTIES CUST 219: WHERE CUST.PARTY_TYPE in ('PERSON', 'ORGANIZATION', 'PARTY_RELATIONSHIP')
220: AND CUST.STATUS IN ('A','I')
221: AND party_id = X_Party_Id;
222: