109: -- fnd_profile.get('SO_ORGANIZATION_ID',so_organization_id);
110: --
111: oe_profile.get('SO_ORGANIZATION_ID',so_organization_id);
112:
113: /*4512781 ar_customer_profile_classes to hz_cust_profile_classes*/
114: begin
115: select cpc.name
116: into profile_class
117: from HZ_CUST_PROFILE_CLASSES cpc
113: /*4512781 ar_customer_profile_classes to hz_cust_profile_classes*/
114: begin
115: select cpc.name
116: into profile_class
117: from HZ_CUST_PROFILE_CLASSES cpc
118: WHERE cpc.status = 'A'
119: AND cpc.profile_class_id = 0;
120: exception
121: when NO_DATA_FOUND then