APPS.HZ_EXTRACT_EXT_ATTRI_BO_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

		select extension_id
		from hz_org_profiles_ext_b
		where organization_profile_id = p_ext_object_id
		and attr_group_id = p_attr_group_id;

Line: 55

		select extension_id
		from hz_per_profiles_ext_b
		where person_profile_id = p_ext_object_id
		and attr_group_id = p_attr_group_id;

Line: 61

		select extension_id
		from hz_party_sites_ext_b
		where party_site_id = p_ext_object_id
		and attr_group_id = p_attr_group_id;

Line: 67

		select extension_id
		from hz_locations_ext_b
		where location_id = p_ext_object_id
		and attr_group_id = p_attr_group_id;

Line: 117

		/*select EGO_ATTR_GROUP_REQUEST_OBJ(
			ATTR_GROUP_ID,
 			APPLICATION_ID,
 			ATTR_GROUP_TYPE,
 			ATTR_GROUP_NAME,
			NULL,
			NULL,
			NULL,
			NULL)*/
		select EGO_USER_ATTRS_DATA_PUB.Build_Attr_Group_Request_Obj(
				ATTR_GROUP_ID,
	 			APPLICATION_ID,
	 			ATTR_GROUP_TYPE,
	 			ATTR_GROUP_NAME,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL,
				NULL)
	--End bug 6503079
		from ego_obj_attr_grp_assocs_v
		where object_name = p_ext_object_name;

Line: 259

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 278

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);

Line: 301

        hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
                               p_prefix=>l_debug_prefix,
                               p_msg_level=>fnd_log.level_procedure);